{"Entry":{"collection":"func","key":"shobj-description","name":"shobj_description","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.1","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.2"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"c9b72fccf2dc82f425f216f23e35dea3baed5f811821681ba9bd1de6bc8decd2","first_version":"8.2","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.344043+08:00","last_version":"20","name":"shobj_description","name_key":"shobj_description","position":28121,"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"],"signature":"shobj_description ( object oid, catalog name ) → text","signature_count":1,"slug":"shobj-description","source_rev":"b7bd9cda","summary":"Returns the comment for a shared database object specified by its OID and the name of the containing system catalog.","summary_zh":""}},"Definition":{"Collection":"func","Key":"shobj-description","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"shobj-description","SourceRevision":"b7bd9cda","Facts":{"description":"Returns the comment for a shared database object specified by its OID and the name of the containing system catalog. This is just like obj_description except that it is used for retrieving comments on shared objects (that is, databases, roles, and tablespaces). Some system catalogs are global to all databases within each cluster, and the descriptions for objects in them are stored globally as well.","description_html":"Returns the comment for a shared database object specified by its OID and the name of the containing system catalog. This is just like \u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e except that it is used for retrieving comments on shared objects (that is, databases, roles, and tablespaces). Some system catalogs are global to all databases within each cluster, and the descriptions for objects in them are stored globally as well.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-COMMENT-TABLE","file":"functions-info.html","slug":"18"},"group":"info","group_label":"System Information Functions And Operators","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Returns the comment for a shared database object specified by its OID and the name of the containing system catalog. This is just like obj_description except that it is used for retrieving comments on shared objects (that is, databases, roles, and tablespaces). Some system catalogs are global to all databases within each cluster, and the descriptions for objects in them are stored globally as well.","description_html":"Returns the comment for a shared database object specified by its OID and the name of the containing system catalog. This is just like \u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e except that it is used for retrieving comments on shared objects (that is, databases, roles, and tablespaces). Some system catalogs are global to all databases within each cluster, and the descriptions for objects in them are stored globally as well.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003eshobj_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":"shobj_description ( object oid, catalog name ) → text","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-COMMENT-TABLE","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"shobj-description","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"shobj_description","Summary":"返回共享数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。此函数与obj_description类似，但用于获取共享对象（即数据库、角色和表空间）的注释。有些系统目录由数据库集簇中的所有数据库全局共享，其中对象的描述也全局存储。","BodyHTML":"返回共享数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。此函数与\u003ccode\u003eobj_description\u003c/code\u003e类似，但用于获取共享对象（即数据库、角色和表空间）的注释。有些系统目录由数据库集簇中的所有数据库全局共享，其中对象的描述也全局存储。\u003cpre\u003eshobj_description ( object oid, catalog name ) → text\u003c/pre\u003e返回共享数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。此函数与\u003ccode\u003eobj_description\u003c/code\u003e类似，但用于获取共享对象（即数据库、角色和表空间）的注释。有些系统目录由数据库集簇中的所有数据库全局共享，其中对象的描述也全局存储。","SourceRevision":"ca936764","ContentHash":"76732a67f756018a01608b09ab9250dc3bfb429ae50efaa9b5f1717cdf964bfe","Payload":{"description_zh":"返回共享数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。此函数与obj_description类似，但用于获取共享对象（即数据库、角色和表空间）的注释。有些系统目录由数据库集簇中的所有数据库全局共享，其中对象的描述也全局存储。","description_zh_html":"返回共享数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。此函数与\u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e类似，但用于获取共享对象（即数据库、角色和表空间）的注释。有些系统目录由数据库集簇中的所有数据库全局共享，其中对象的描述也全局存储。","signatures":[{"description_zh":"返回共享数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。此函数与obj_description类似，但用于获取共享对象（即数据库、角色和表空间）的注释。有些系统目录由数据库集簇中的所有数据库全局共享，其中对象的描述也全局存储。","description_zh_html":"返回共享数据库对象的注释，对象由其 OID 和所在系统目录的名称指定。此函数与\u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e类似，但用于获取共享对象（即数据库、角色和表空间）的注释。有些系统目录由数据库集簇中的所有数据库全局共享，其中对象的描述也全局存储。","returns":"text","text":"shobj_description ( object oid, catalog name ) → text","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":[{"Version":"18","Ordinal":0,"Hash":"54753f44073ef5c9b797405d7955f9485a248b3c2bcb8c3684923bcb8c18245d","Text":"shobj_description ( object oid, catalog name ) → text","Returns":"text","Payload":{"description":"Returns the comment for a shared database object specified by its OID and the name of the containing system catalog. This is just like obj_description except that it is used for retrieving comments on shared objects (that is, databases, roles, and tablespaces). Some system catalogs are global to all databases within each cluster, and the descriptions for objects in them are stored globally as well.","description_html":"Returns the comment for a shared database object specified by its OID and the name of the containing system catalog. This is just like \u003ccode class=\"function\"\u003eobj_description\u003c/code\u003e except that it is used for retrieving comments on shared objects (that is, databases, roles, and tablespaces). Some system catalogs are global to all databases within each cluster, and the descriptions for objects in them are stored globally as well.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003eshobj_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":"shobj_description ( object oid, catalog name ) → text","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}