Updated on 2024-03-14 GMT+08:00

PG_NAMESPACE

PG_NAMESPACE records the namespaces, that is, schema-related information. The nsptype column is added to the cloud native data warehouse 3.0 to distinguish external schemas from common schemas. The value of external schema is e, and the value of common schema is i.

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.