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

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 a 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.

nspblockchain

Boolean

Specifies whether the mode is the tamper-proof mode.

  • true: The mode is the tamper-proof mode.
  • false: The mode is not the tamper-proof mode.

nspcollation

oid

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