PostgreSQL的schema信息，存储于何处

查看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，如需转载请自行联系原作者