Updated on 2025-08-25 GMT+08:00

PG_NAMESPACE

PG_NAMESPACE stores 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 is valid only on DNs.

nspacl

aclitem[]

Access permissions. For details, see GRANT and REVOKE.

permspace

bigint

Permanent tablespace quota for the schema.

usedspace

bigint

Size of the used permanent tablespace for the schema.