# 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                                         |
| :--------- | :-------- | :------------ | :-------------------------------------------------- |
|`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
|`nsptsoid`|	oid		|pg_tablespace.oid|defualt tablespace of the namespace