查看库名、表名、字段


select datname from pg_database;

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';

SELECT column_name FROM information_schema.columns WHERE table_name ='pda_ub_tips';

posted on 2016-05-24 14:09  fsgui  阅读(140)  评论(0)    收藏  举报