The catalogpg_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 49.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; seeGRANT andREVOKE for details |
