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