要列出所有模式,请使用(ANSI)标准INFORMATION_SCHEMA
select schema_name from information_schema.schemata
手册中的更多细节:http://www.postgresql.org/docs/current/static/information-schema.html
或者:
select nspname from pg_catalog.pg_namespace;
有关手册中pg_catalog的更多详细信息:http://www.postgresql.org/docs/current/static/catalogs.html