The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. without name conflicts.
Table 42-23. pg_namespace Columns
| Name |
Type |
References |
Description |
|
nspname
|
name
|
|
Name of the namespace |
|
nspowner
|
oid
|
pg_authid
.oid
|
Owner of the namespace |
|
nspacl
|
aclitem[]
|
|
Access privileges; see
GRANT
and
REVOKE
for details. |