查看schema信息：
[pgsql@localhost bin]$ ./psql psql (9.1.2) Type "help" for help. pgsql=# create schema gaosche; CREATE SCHEMA pgsql=# select catalog_name,schema_name from information_schema.schemata ; catalog_name | schema_name --------------+-------------------- pgsql | pg_toast pgsql | pg_temp_1 pgsql | pg_toast_temp_1 pgsql | pg_catalog pgsql | public pgsql | information_schema pgsql | gaosche (7 rows) pgsql=# select * from pg_namespace; nspname | nspowner | nspacl --------------------+----------+---------------------------- pg_toast | 10 | pg_temp_1 | 10 | pg_toast_temp_1 | 10 | pg_catalog | 10 | {pgsql=UC/pgsql,=U/pgsql} public | 10 | {pgsql=UC/pgsql,=UC/pgsql} information_schema | 10 | {pgsql=UC/pgsql,=U/pgsql} gaosche | 10 | (7 rows) pgsql=#
故此，可以任务，schema，就是namespace。
本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3171325.html，如需转载请自行联系原作者
