The pg_namespace system catalog table stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. without name conflicts.
| column | 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 as given by GRANT and REVOKE |
Parent topic: System Catalogs Definitions
Content feedback and comments