PG_NAMESPACE

PG_NAMESPACE records the namespaces, that is, schema-related information.

Table 1 PG_NAMESPACE columns

Name

Type

Description

nspname

name

Name of the namespace

nspowner

oid

Owner of the namespace

nsptimeline

bigint

Timeline when the namespace is created on the DN This column is for internal use and valid only on the DN.

nspacl

aclitem[]

Access permissions For details, see GRANT and REVOKE.

permspace

bigint

Quota of a schema's permanent tablespace

usedspace

bigint

Used size of a schema's permanent tablespace