pg_namespace is a system catalogue table which defines PostgreSQL's schemas.
pg_namespace was introduced in PostgreSQL 7.3 (commit a25b94c0).
psql commands
In psql, the slash command \dn displays the available schemas.
Definition by PostgreSQL version
pg_namespace (PostgreSQL 13)
Table "pg_catalog.pg_namespace"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
oid | oid | | not null |
nspname | name | | not null |
nspowner | oid | | not null |
nspacl | aclitem[] | | |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 12)
Table "pg_catalog.pg_namespace"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
oid | oid | | not null |
nspname | name | | not null |
nspowner | oid | | not null |
nspacl | aclitem[] | | |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 11)
Table "pg_catalog.pg_namespace"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
nspname | name | | not null |
nspowner | oid | | not null |
nspacl | aclitem[] | | |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 10)
Table "pg_catalog.pg_namespace"
Column | Type | Collation | Nullable | Default
----------+-----------+-----------+----------+---------
nspname | name | | not null |
nspowner | oid | | not null |
nspacl | aclitem[] | | |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 9.6)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 9.5)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 9.4)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 9.3)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 9.2)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 9.1)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 9.0)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 8.4)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 8.3)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
pg_namespace (PostgreSQL 8.2)
Table "pg_catalog.pg_namespace"
Column | Type | Modifiers
----------+-----------+-----------
nspname | name | not null
nspowner | oid | not null
nspacl | aclitem[] |
Indexes:
"pg_namespace_nspname_index" UNIQUE, btree (nspname)
"pg_namespace_oid_index" UNIQUE, btree (oid)
Documentation: pg_namespace
Change history
This table has not changed since it was first added.
Examples
postgres=# CREATE SCHEMA someschema;
CREATE SCHEMA
postgres=# \dn
List of schemas
Name | Owner
------------+----------
public | postgres
someschema | postgres
(2 rows)
postgres=# SELECT * FROM pg_namespace;
nspname | nspowner | nspacl
--------------------+----------+-------------------------------------
pg_toast | 10 |
pg_temp_1 | 10 |
pg_toast_temp_1 | 10 |
pg_catalog | 10 | {postgres=UC/postgres,=U/postgres}
public | 10 | {postgres=UC/postgres,=UC/postgres}
information_schema | 10 | {postgres=UC/postgres,=U/postgres}
someschema | 10 |
(7 rows)
References
- PostgreSQL documentation: pg_namespace