Help Center/GaussDB/Developer Guide(Distributed_V2.0-3.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. If the database object isolation attribute is enabled, users can view only the schema information that they have the permission to access.

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 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 permission. For details, see GRANT and REVOKE.

in_redistribution

"char"

Specifies whether the content is in the redistribution state.

nspcollation

oid

Default collation of the namespace (a value may exist only when sql_compatibility is set to 'MYSQL').

Parent topic:System Catalogs