要列出所有模式,请使用(ANSI)标准INFORMATION_SCHEMA
原文链接:https://www.f2er.com/postgresql/192372.htmlselect 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