PG_NAMESPACE

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

Table 1 PG_NAMESPACE columns

Column

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

nsptype

Char

Distinguishes external schemas from common schemas. This parameter is supported only in 8.3.0 and later versions to adapt to LakeFormation features.

Note

The nsptype field is added to distinguish external schemas from common schemas.

  • e indicates an external schema.

  • i indicates a common schema.