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 52.32. pg_namespace Columns
| Name |
Type |
References |
Description |
oid |
oid |
|
Row identifier (hidden attribute; must be explicitly selected) |
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 |