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 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 For details, see 7.13.12.1 GRANT and 7.13.17.9 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 'b').