PostgreSQL日常管理

查询schema：

 select nspname from pg_namespace;

查询数据库

select datname from pg_database;

查询表

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