pg_namespace#

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.

Table 1. pg_catalog.pg_namespace

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.

nspdboid

oid

the oid of the database namespace belong to.