{"Entry":{"collection":"func","key":"obj-description","name":"obj_description","aliases":[],"metadata":{"changed_in":["7.4"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"7.1","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"7.2"},{"descriptions_changed":true,"doc_overhaul":false,"from":"7.3","group_changed":null,"signatures":{"added":["obj_description ( object_oid, catalog_name ) → text","obj_description ( object_oid ) → text"],"removed":["obj_description ( objectOID, tablename ) → text","obj_description ( objectOID ) → text"]},"status":"changed","to":"7.4"},{"descriptions_changed":false,"doc_overhaul":false,"from":"7.4","group_changed":{"from":"misc","to":"info"},"signatures":{"added":[],"removed":[]},"status":"changed","to":"8.0"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"5b897cf0b221d71dcb98b4f7c5e5926978de3d1045d08929963f12ef6978cfaf","derived_content_hash":"3ee87418d83f464399b68248a4c95a8516e1f48a97df614a844c879b80a4a30a","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:63a646a15af5b5b04878300319841d5d6eb7c6162f2f60de30c8e9fff58d5634","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"7.2","group":"info","group_label":"System Information Functions And Operators","groups":["misc","info"],"imported_at":"2026-09-27T17:57:29.112682+08:00","last_version":"20","name":"obj_description","name_key":"obj_description","position":28032,"present_in":["7.2","7.3","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"],"repair_provenance":{"original_source_revision":"wiki-repair-20261023:5f6562b3213a46d9ef9f9aa709f576804ce4243a759d689265d198ab11e1caf3","receipt_sha256":"fd6c9d834caeaa9a8e0ffea57c9cf4e5fae8f5ebb6e529a41a3eb08f04499ab0","repair":"wiki-repair-20261023"},"signature":"obj_description ( object oid, catalog name ) → text","signature_count":2,"slug":"obj-description","source_rev":"wiki-repair-20261023:63a646a15af5b5b04878300319841d5d6eb7c6162f2f60de30c8e9fff58d5634","summary":"Returns the comment for a database object specified by its OID and the name of the containing system catalog.","summary_zh":""}},"Definition":{"Collection":"func","Key":"obj-description","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"obj-description","SourceRevision":"wiki-repair-20261023:63a646a15af5b5b04878300319841d5d6eb7c6162f2f60de30c8e9fff58d5634","Facts":{"description":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.","description_html":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, \u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e would retrieve the comment for the table with OID 123456.","description_zh":"返回数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。例如，obj_description(123456, 'pg_class') 会获取 OID 为 123456 的表的注释。","description_zh_html":"返回数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。例如，\u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e 会获取 OID 为 123456 的表的注释。","doc":{"anchor":"FUNCTIONS-INFO-COMMENT-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"info","group_label":"系统信息函数和操作符","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.","description_html":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, \u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e would retrieve the comment for the table with OID 123456.","description_zh":"返回数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。例如，obj_description(123456, 'pg_class') 会获取 OID 为 123456 的表的注释。","description_zh_html":"返回数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。例如，\u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e 会获取 OID 为 123456 的表的注释。","examples":[],"html":"\u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatalog\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"obj_description ( object oid, catalog name ) → text","zh_from":"same-version-manual"},{"description":"Returns the comment for a database object specified by its OID alone. This is deprecated since there is no guarantee that OIDs are unique across different system catalogs; therefore, the wrong comment might be returned.","description_html":"Returns the comment for a database object specified by its OID alone. This is \u003cspan class=\"emphasis\"\u003e\u003cem\u003edeprecated\u003c/em\u003e\u003c/span\u003e since there is no guarantee that OIDs are unique across different system catalogs; therefore, the wrong comment might be returned.","description_zh":"返回仅由其 OID 指定的数据库对象的注释。此形式已弃用，因为无法保证 OID 在不同系统目录之间唯一，因而可能返回错误的注释。","description_zh_html":"返回仅由其 OID 指定的数据库对象的注释。此形式\u003cspan class=\"emphasis\"\u003e\u003cem\u003e已弃用\u003c/em\u003e\u003c/span\u003e，因为无法保证 OID 在不同系统目录之间唯一，因而可能返回错误的注释。","examples":[],"html":"\u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"obj_description ( object oid ) → text","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-info.html","sha256":"7c33185e79430cfbda432dc4db277115c7ac846afccadfcf904ceb1bf2aa1ba5"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-COMMENT-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"obj-description","SourceDatabase":"center","Version":"18","Locale":"en","Title":"obj_description","Summary":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.","BodyHTML":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, \u003ccode\u003eobj_description(123456, \u0026#39;pg_class\u0026#39;)\u003c/code\u003e would retrieve the comment for the table with OID 123456.","SourceRevision":"wiki-repair-20261023:63a646a15af5b5b04878300319841d5d6eb7c6162f2f60de30c8e9fff58d5634","ContentHash":"7f49ada15172d875a8a5565d5dd6191cd4e7d77530bfa90e0467082d9db1901f","Payload":{"description":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.","description_html":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, \u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e would retrieve the comment for the table with OID 123456.","signatures":[{"description":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.","description_html":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, \u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e would retrieve the comment for the table with OID 123456.","description_zh":"返回数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。例如，obj_description(123456, 'pg_class') 会获取 OID 为 123456 的表的注释。","description_zh_html":"返回数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。例如，\u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e 会获取 OID 为 123456 的表的注释。","examples":[],"html":"\u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatalog\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"obj_description ( object oid, catalog name ) → text","zh_from":"same-version-manual"},{"description":"Returns the comment for a database object specified by its OID alone. This is deprecated since there is no guarantee that OIDs are unique across different system catalogs; therefore, the wrong comment might be returned.","description_html":"Returns the comment for a database object specified by its OID alone. This is \u003cspan class=\"emphasis\"\u003e\u003cem\u003edeprecated\u003c/em\u003e\u003c/span\u003e since there is no guarantee that OIDs are unique across different system catalogs; therefore, the wrong comment might be returned.","description_zh":"返回仅由其 OID 指定的数据库对象的注释。此形式已弃用，因为无法保证 OID 在不同系统目录之间唯一，因而可能返回错误的注释。","description_zh_html":"返回仅由其 OID 指定的数据库对象的注释。此形式\u003cspan class=\"emphasis\"\u003e\u003cem\u003e已弃用\u003c/em\u003e\u003c/span\u003e，因为无法保证 OID 在不同系统目录之间唯一，因而可能返回错误的注释。","examples":[],"html":"\u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"obj_description ( object oid ) → text","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.2","7.3","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":[{"Version":"18","Ordinal":0,"Hash":"2cf94b53775a906920b4d8bd26529bf69197c2589e485ae4465bd49d3ead16c9","Text":"obj_description ( object oid, catalog name ) → text","Returns":"text","Payload":{"description":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, obj_description(123456, 'pg_class') would retrieve the comment for the table with OID 123456.","description_html":"Returns the comment for a database object specified by its OID and the name of the containing system catalog. For example, \u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e would retrieve the comment for the table with OID 123456.","description_zh":"返回数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。例如，obj_description(123456, 'pg_class') 会获取 OID 为 123456 的表的注释。","description_zh_html":"返回数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。例如，\u003ccode class=\"literal\"\u003eobj_description(123456, 'pg_class')\u003c/code\u003e 会获取 OID 为 123456 的表的注释。","examples":[],"html":"\u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatalog\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"obj_description ( object oid, catalog name ) → text","zh_from":"same-version-manual"}},{"Version":"18","Ordinal":1,"Hash":"923df53e251a34026e802b47984573b609d5bf057cb67a9d64f497f1bbe07a0d","Text":"obj_description ( object oid ) → text","Returns":"text","Payload":{"description":"Returns the comment for a database object specified by its OID alone. This is deprecated since there is no guarantee that OIDs are unique across different system catalogs; therefore, the wrong comment might be returned.","description_html":"Returns the comment for a database object specified by its OID alone. This is \u003cspan class=\"emphasis\"\u003e\u003cem\u003edeprecated\u003c/em\u003e\u003c/span\u003e since there is no guarantee that OIDs are unique across different system catalogs; therefore, the wrong comment might be returned.","description_zh":"返回仅由其 OID 指定的数据库对象的注释。此形式已弃用，因为无法保证 OID 在不同系统目录之间唯一，因而可能返回错误的注释。","description_zh_html":"返回仅由其 OID 指定的数据库对象的注释。此形式\u003cspan class=\"emphasis\"\u003e\u003cem\u003e已弃用\u003c/em\u003e\u003c/span\u003e，因为无法保证 OID 在不同系统目录之间唯一，因而可能返回错误的注释。","examples":[],"html":"\u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003etext\u003c/code\u003e","returns":"text","text":"obj_description ( object oid ) → text","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}