@H_404_0@1、相当与MysqL的show databases; @H_404_0@select datname from pg_database;

@H_404_5@

@H_404_0@2、相当于MysqL的show tables; @H_404_0@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';public 是默认的schema的名字

@H_404_5@

@H_404_0@3、相当与MysqL的describe table_name; @H_404_0@SELECT column_name FROM information_schema.columns WHERE table_name ='table_name'; @H_404_0@'table_name'是要查询的表的名字 原文链接：https://www.f2er.com/postgresql/195634.html