Catalogs: pg_namespace

The catalog pg_namespace 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 50-32. pg_namespace Columns

Name	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; see GRANT and REVOKE for details

Prev		Next
`pg_largeobject_metadata`	Up	`pg_opclass`

Links:

https://www.postgresql.org/docs/9.6/static/catalog-pg-namespace.html

doc_PostgreSQL

2016-10-12 11:32:33

Comments

Popular Articles

Catalogs: pg_statistic The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by ANALYZE and subsequently used by the quer

Catalogs: pg_opclass The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular data typ

Catalogs: pg_rewrite The catalog pg_rewrite stores rewrite rules for tables and views. Table 50-41. pg_rewrite Columns Name Type References Description oid oid Row id

Catalogs: pg_indexes The view pg_indexes provides access to useful information about each index in the database. Table 50-65. pg_indexes Columns Name Type References De

Catalogs: pg_class The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but see als