Updated on 2026-07-02 GMT+08:00

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

Permanent tablespace quota of the schema, in bytes

usedspace

bigint

Used permanent tablespace size of the schema, in bytes

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.