{"Entry":{"collection":"catalog","key":"pg_description","name":"pg_description","aliases":[],"metadata":{"changed_in":["9.5"],"changes":[{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"7.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Arbitrary text that serves as the description of this object.","name":"description","to":"Arbitrary text that serves as the description of this object"},{"from":"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.","name":"objsubid","to":"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"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"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","name":"objsubid","to":"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."}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"not_null","from":false,"name":"description","to":true}],"description_changed":false,"descriptions":[],"from":"9.4","listing":[],"order":false,"removed":[],"status":"changed","to":"9.5","types":[],"unlisted":[]}],"column_count":4,"content_hash":"7fd39747269193de66242a385148a88c322cdd31bb3c4c428834f979b0ff6596","derived_content_hash":"80b93aad87aa35c662e121bc23483453e72e7df70043220d05a62691fdd984f2","first_version":"7.4","imported_at":"2026-09-30T00:40:55.512595+08:00","kind":"catalog","last_version":"20","name":"pg_description","position":24,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:011c7bea1fdba86738e81fc56640e7346bd1ad2b5dc4d7527950d547225c7f2a","summary":"The catalog pg_description stores optional descriptions (comments) for each database object.","summary_zh":"目录 pg_description 存储对每一个数据库对象可选的描述（注释）。描述可以通过 COMMENT 操作，并可使用 psql 的\\d 命令查看。在 pg_description 的初始内容中提供了很多内置系统对象的描述。"}},"Definition":{"Collection":"catalog","Key":"pg_description","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_description","SourceRevision":"catalog-bilingual-repair:011c7bea1fdba86738e81fc56640e7346bd1ad2b5dc4d7527950d547225c7f2a","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the object this description pertains to","description_zh":"描述所属对象的 OID","documented":true,"documented_name":"objoid","hidden":false,"name":"objoid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the system catalog this object appears in","description_zh":"该对象所在的系统目录的 OID","documented":true,"documented_name":"classoid","hidden":false,"name":"classoid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"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_zh":"对于一个表列上的一个注释，这里是列号（objoid 和 classoid 指表本身）。对所有其他对象类型，此列为 0。","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Arbitrary text that serves as the description of this object","description_zh":"作为该对象描述的任意文本","documented":true,"documented_name":"description","hidden":false,"name":"description","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and viewed with psql's \\d commands. Descriptions of many built-in system objects are provided in the initial contents of pg_description.\n\nSee also pg_shdescription, which performs a similar function for descriptions involving objects that are shared across a database cluster.","description_zh":"目录 pg_description 存储对每一个数据库对象可选的描述（注释）。描述可以通过 COMMENT 操作，并可使用 psql 的\\d 命令查看。在 pg_description 的初始内容中提供了很多内置系统对象的描述。\n\n参见 pg_shdescription，它对在一个数据库集簇中共享的对象的描述提供了相似的功能。","description_zh_html":"\u003cp\u003e目录 pg_description 存储对每一个数据库对象可选的描述（注释）。描述可以通过 COMMENT 操作，并可使用 psql 的\\d 命令查看。在 pg_description 的初始内容中提供了很多内置系统对象的描述。\u003c/p\u003e\n\u003cp\u003e参见 pg_shdescription，它对在一个数据库集簇中共享的对象的描述提供了相似的功能。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.21.5","file":"catalog-pg-description.html","lang":"en","sha256":"39d05e815c88504100ab4e545a08d60988a80e8a0aea143108d0ca632b2881bc","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","objsubid","description"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-description.html","sha256":"0429f76b2beef0d1e6f9f77e81e03ad0aba3e989817f4ac9ac41c0f0f38a14c2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:d59e2bd55537c8f38b51ee3659fff2c2b6b09bc906bcfb6d12827130aea89021","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.21.5","file":"catalog-pg-description.html","lang":"en","sha256":"39d05e815c88504100ab4e545a08d60988a80e8a0aea143108d0ca632b2881bc","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-description.html","sha256":"0429f76b2beef0d1e6f9f77e81e03ad0aba3e989817f4ac9ac41c0f0f38a14c2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:d59e2bd55537c8f38b51ee3659fff2c2b6b09bc906bcfb6d12827130aea89021","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","objsubid","description"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_description","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_description","Summary":"The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and viewed with psql's \\d commands. Descriptions of many built-in system objects are provided in the initial contents of pg_description.\n\nSee also pg_shdescription, which performs a similar function for descriptions involving objects that are shared across a database cluster.","BodyHTML":"\u003cp\u003eThe catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and viewed with psql\u0026#39;s \\d commands. Descriptions of many built-in system objects are provided in the initial contents of pg_description.\n\nSee also pg_shdescription, which performs a similar function for descriptions involving objects that are shared across a database cluster.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:011c7bea1fdba86738e81fc56640e7346bd1ad2b5dc4d7527950d547225c7f2a","ContentHash":"fabb5985ac70437d8b899912927c6bd05848fdb9677f04d7d75ac6c72b899768","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the object this description pertains to","description_zh":"描述所属对象的 OID","documented":true,"documented_name":"objoid","hidden":false,"name":"objoid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the system catalog this object appears in","description_zh":"该对象所在的系统目录的 OID","documented":true,"documented_name":"classoid","hidden":false,"name":"classoid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"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_zh":"对于一个表列上的一个注释，这里是列号（objoid 和 classoid 指表本身）。对所有其他对象类型，此列为 0。","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Arbitrary text that serves as the description of this object","description_zh":"作为该对象描述的任意文本","documented":true,"documented_name":"description","hidden":false,"name":"description","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the COMMENT command and viewed with psql's \\d commands. Descriptions of many built-in system objects are provided in the initial contents of pg_description.\n\nSee also pg_shdescription, which performs a similar function for descriptions involving objects that are shared across a database cluster."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}