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