Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ System Catalogs and System Views/ System Catalogs/ PG_NAMESPACE
Updated on 2025-08-19 GMT+08:00
View PDF

PG_NAMESPACE

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

Table 1 PG_NAMESPACE columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

nspname

name

Name of a namespace

nspowner

oid

Owner of a namespace

nsptimeline

bigint

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

nspacl

aclitem[]

Access permission

in_redistribution

"char"

Specifies whether the content is in the redistribution state.

nspblockchain

boolean
  • If the value is true, the tamper-proof schema is used.
  • If the value is false, the non-tamper-proof schema is used.
Parent topic: System Catalogs