postgresql jdbc命令转换

http://www.linuxscrew.com/2009/07/03/postgresql-show-tables-show-databases-show-columns/

PostgreSQL is one of the best database engines for an average web project and many who moves to psql from mysql (for example) often ask the following questions: what  is the analog of “show tables” in postgres? or how can I get the list of databases in postgres like “show databases” in mysql? The answers are short:

mysql: SHOW TABLES
postgresql: d
postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';

mysql: SHOW DATABASES
postgresql: l
postgresql: SELECT datname FROM pg_database;

mysql: SHOW COLUMNS
postgresql: d table
postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';

mysql: DESCRIBE TABLE
postgresql: d+ table
postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';

最后

以上就是健壮砖头为你收集整理的postgresql jdbc命令转换的全部内容，希望文章能够帮你解决postgresql jdbc命令转换所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。