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. |