{"Entry":{"collection":"catalog","key":"pg_shdescription","name":"pg_shdescription","aliases":[],"metadata":{"changed_in":["9.5"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.1","order":false,"removed":[],"status":"added","to":"8.2","types":[]},{"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":3,"content_hash":"00dfcfa0e642bac83c11fcdc01603fb04bfcde5ad68f0231fa5aa0f8b0949b31","derived_content_hash":"8f73d66067ae66c30ad0e37eb88610761ca28e5df04c457e6a1c9a686ff0d5b3","first_version":"8.2","imported_at":"2026-09-30T00:40:55.827687+08:00","kind":"catalog","last_version":"20","name":"pg_shdescription","position":77,"present_in":["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:ef3c8d82515e9910521a6ff000e02899a54578e248ae19c1c23cfd0aaec929a4","summary":"The catalog pg_shdescription stores optional descriptions (comments) for shared database objects.","summary_zh":"目录 pg_shdescription 存储共享数据库对象的可选描述（注释）。这些描述可以通过 COMMENT 命令设置或修改，并且可以使用 psql 的\\d 命令查看。"}},"Definition":{"Collection":"catalog","Key":"pg_shdescription","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_shdescription","SourceRevision":"catalog-bilingual-repair:ef3c8d82515e9910521a6ff000e02899a54578e248ae19c1c23cfd0aaec929a4","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":"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_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the COMMENT command and viewed with psql's \\d commands.\n\nSee also pg_description, which performs a similar function for descriptions involving objects within a single database.\n\nUnlike 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.","description_zh":"目录 pg_shdescription 存储共享数据库对象的可选描述（注释）。这些描述可以通过 COMMENT 命令设置或修改，并且可以使用 psql 的\\d 命令查看。\n\n另请参阅 pg_description，它对单个数据库内对象的描述提供了相似的功能。\n\n与大部分其他系统目录不同，pg_shdescription 在整个集簇的所有数据库之间共享：在每一个集簇中只有一个 pg_shdescription 的拷贝，而不是每个数据库一份。","description_zh_html":"\u003cp\u003e目录 pg_shdescription 存储共享数据库对象的可选描述（注释）。这些描述可以通过 COMMENT 命令设置或修改，并且可以使用 psql 的\\d 命令查看。\u003c/p\u003e\n\u003cp\u003e另请参阅 pg_description，它对单个数据库内对象的描述提供了相似的功能。\u003c/p\u003e\n\u003cp\u003e与大部分其他系统目录不同，pg_shdescription 在整个集簇的所有数据库之间共享：在每一个集簇中只有一个 pg_shdescription 的拷贝，而不是每个数据库一份。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.51.6","file":"catalog-pg-shdescription.html","lang":"en","sha256":"264242f99400683116d4a54e4b5a24ef3c8c18357d0b119319a8fe205e741a06","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","description"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-shdescription.html","sha256":"c010b30e58377a0414c427c1b48e85393ad45d3221852afa185e28b9ea0053f1","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:98cd81b1e8d0887a88377f36e5a6df05a29f822662711bf98c9eab92b228009a","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.51.6","file":"catalog-pg-shdescription.html","lang":"en","sha256":"264242f99400683116d4a54e4b5a24ef3c8c18357d0b119319a8fe205e741a06","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-shdescription.html","sha256":"c010b30e58377a0414c427c1b48e85393ad45d3221852afa185e28b9ea0053f1","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:98cd81b1e8d0887a88377f36e5a6df05a29f822662711bf98c9eab92b228009a","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","description"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_shdescription","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_shdescription","Summary":"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.\n\nSee also pg_description, which performs a similar function for descriptions involving objects within a single database.\n\nUnlike 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.","BodyHTML":"\u003cp\u003eThe catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the COMMENT command and viewed with psql\u0026#39;s \\d commands.\n\nSee also pg_description, which performs a similar function for descriptions involving objects within a single database.\n\nUnlike 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:ef3c8d82515e9910521a6ff000e02899a54578e248ae19c1c23cfd0aaec929a4","ContentHash":"ff13478c0c6cc403685f1372d521e9c1371855f9af2c4692b16aef900eb02d4b","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":"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_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the COMMENT command and viewed with psql's \\d commands.\n\nSee also pg_description, which performs a similar function for descriptions involving objects within a single database.\n\nUnlike 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."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","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}