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.

    columntypereferencesdescription
    oidoid Row identifier (hidden attribute; must be explicitly selected)
    nspnamename Name of the namespace
    nspowneroidpg_authid.oidOwner of the namespace
    nspaclaclitem[] Access privileges as given by GRANT and REVOKE

    Parent topic: System Catalogs Definitions