历史版本。 PostgreSQL 9.1 已结束支持。 2016-10-27. 请参阅 当前版本手册.
45.19. pg_description #
目录pg_description存储对每一个数据库对象可选的描述(注释)。描述可以通过COMMENT操作,并可使用psql的\d命令查看。在pg_description的初始内容中提供了很多内置系统对象的描述。
参见pg_shdescription,它对在一个数据库集簇中共享的对象的描述提供了相似的功能。
表 45.19. pg_description 列
| Name | Type | References | Description |
|---|---|---|---|
objoid | oid | any OID column | The OID of the object this description pertains to |
classoid | oid | | The OID of the system catalog this object appears in |
objsubid | int4 | For a comment on a table column, this is the column number (the
objoid and classoid refer to
the table itself). For all other object types, this column is
zero.
| |
description | text | Arbitrary text that serves as the description of this object |