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