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 |