查看库名、表名、字段


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  阅读(133)  评论(0编辑  收藏  举报