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

2025-01-10 15:47:30

Comments

Popular Articles

Catalogs: pg_operator The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.12 for more information. Table 50-34. pg_operator Co

Catalogs: pg_description The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command

Catalogs: pg_range The catalog pg_range stores information about range types. This is in addition to the types' entries in pg_type. Table 50-39. pg_range Columns Name

Catalogs: pg_transform The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See CREATE TRANSFORM

Catalogs: pg_config The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL. It is intended, for example,