Postgresql 中文操作指南

53.49. pg_shdescription #

目录 pg_shdescription 为共享的数据库对象存储可选说明(注释)。可以使用 COMMENT 命令操作说明,并可以使用 psql 的 \d 命令查看说明。

The catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the COMMENT command and viewed with psql’s \d commands.

另请参见 pg_description ,该函数执行类似的操作以描述单个数据库中的对象。

See also pg_description, which performs a similar function for descriptions involving objects within a single database.

与大多数系统目录不同,pg_shdescription 在群集的所有数据库之间共享:每个群集只有一个 pg_shdescription 副本,而不是每个数据库一个。

Unlike most system catalogs, pg_shdescription is shared across all databases of a cluster: there is only one copy of pg_shdescription per cluster, not one per database.

Table 53.49. pg_shdescription Columns

Table 53.49. pg_shdescription Columns

Column Type

Description

objoid oid (references any OID column)

The OID of the object this description pertains to

classoid oid (references pg_class.oid)

The OID of the system catalog this object appears in

description text

Arbitrary text that serves as the description of this object