查看schema信息:
[pgsql@localhost bin]$ ./psqlpsql (9.1.2)Type "help" for help.pgsql=# create schema gaosche;CREATE SCHEMApgsql=# 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。