{"Entry":{"collection":"func","key":"pg-identify-object-as-address","name":"pg_identify_object_as_address","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.5"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"1313ca8178d0c7c9ead0183697f50b8c064de94ceb30b744aac7abfd7a64aa64","derived_content_hash":"3b2a5acbb0cc4770c1ba318695933512674f1e42c52c4fcb40a33b6430986d40","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:65593c3f059660ca8f9c8b025d59d5bd45058d4c6fcee7abe6d35a95726b5e92","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"9.5","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.241359+08:00","last_version":"20","name":"pg_identify_object_as_address","name_key":"pg_identify_object_as_address","position":28080,"present_in":["9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"31e8ff1be55afe9e337f269b339fc2c5491e5964ffeeee3c99001301e422d1e3","repair":"wiki-repair-20261023"},"signature":"pg_identify_object_as_address ( classid oid, objid oid, objsubid integer ) → record ( type text, object_names text[], object_args text[] )","signature_count":1,"slug":"pg-identify-object-as-address","source_rev":"wiki-repair-20261023:65593c3f059660ca8f9c8b025d59d5bd45058d4c6fcee7abe6d35a95726b5e92","summary":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-identify-object-as-address","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-identify-object-as-address","SourceRevision":"wiki-repair-20261023:65593c3f059660ca8f9c8b025d59d5bd45058d4c6fcee7abe6d35a95726b5e92","Facts":{"description":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. type identifies the type of database object; object_names and object_args are text arrays that together form a reference to the object. These three values can be passed to pg_get_object_address to obtain the internal address of the object.","description_html":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e are text arrays that together form a reference to the object. These three values can be passed to \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e to obtain the internal address of the object.","description_zh":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。type 标识数据库对象的类型；object_names 和 object_args 是 text 数组，共同构成对该对象的引用。将这三个值传给 pg_get_object_address 可以获得对象的内部地址。","description_zh_html":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。\u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e 标识数据库对象的类型；\u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e 是 text 数组，共同构成对该对象的引用。将这三个值传给 \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e 可以获得对象的内部地址。","doc":{"anchor":"FUNCTIONS-INFO-OBJECT-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 a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. type identifies the type of database object; object_names and object_args are text arrays that together form a reference to the object. These three values can be passed to pg_get_object_address to obtain the internal address of the object.","description_html":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e are text arrays that together form a reference to the object. These three values can be passed to \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e to obtain the internal address of the object.","description_zh":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。type 标识数据库对象的类型；object_names 和 object_args 是 text 数组，共同构成对该对象的引用。将这三个值传给 pg_get_object_address 可以获得对象的内部地址。","description_zh_html":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。\u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e 标识数据库对象的类型；\u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e 是 text 数组，共同构成对该对象的引用。将这三个值传给 \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e 可以获得对象的内部地址。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_identify_object_as_address\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eclassid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjsubid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e )","returns":"record","text":"pg_identify_object_as_address ( classid oid, objid oid, objsubid integer ) → record ( type text, object_names text[], object_args 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-OBJECT-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-identify-object-as-address","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_identify_object_as_address","Summary":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. type identifies the type of database object; object_names and object_args are text arrays that together form a reference to the object. These three values can be passed to pg_get_object_address to obtain the internal address of the object.","BodyHTML":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. \u003cem\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e and \u003cem\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e are text arrays that together form a reference to the object. These three values can be passed to \u003ccode\u003epg_get_object_address\u003c/code\u003e to obtain the internal address of the object.","SourceRevision":"wiki-repair-20261023:65593c3f059660ca8f9c8b025d59d5bd45058d4c6fcee7abe6d35a95726b5e92","ContentHash":"ba426d3af471911eec6180be7463c36dd74af72ba49111f7bf3a2b65d142122a","Payload":{"description":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. type identifies the type of database object; object_names and object_args are text arrays that together form a reference to the object. These three values can be passed to pg_get_object_address to obtain the internal address of the object.","description_html":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e are text arrays that together form a reference to the object. These three values can be passed to \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e to obtain the internal address of the object.","signatures":[{"description":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. type identifies the type of database object; object_names and object_args are text arrays that together form a reference to the object. These three values can be passed to pg_get_object_address to obtain the internal address of the object.","description_html":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e are text arrays that together form a reference to the object. These three values can be passed to \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e to obtain the internal address of the object.","description_zh":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。type 标识数据库对象的类型；object_names 和 object_args 是 text 数组，共同构成对该对象的引用。将这三个值传给 pg_get_object_address 可以获得对象的内部地址。","description_zh_html":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。\u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e 标识数据库对象的类型；\u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e 是 text 数组，共同构成对该对象的引用。将这三个值传给 \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e 可以获得对象的内部地址。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_identify_object_as_address\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eclassid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjsubid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e )","returns":"record","text":"pg_identify_object_as_address ( classid oid, objid oid, objsubid integer ) → record ( type text, object_names text[], object_args text[] )","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"2987297ab36a02e1e83ff910c179d313fbcea76b673a51e97b50ddb71ee4b88c","Text":"pg_identify_object_as_address ( classid oid, objid oid, objsubid integer ) → record ( type text, object_names text[], object_args text[] )","Returns":"record","Payload":{"description":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. type identifies the type of database object; object_names and object_args are text arrays that together form a reference to the object. These three values can be passed to pg_get_object_address to obtain the internal address of the object.","description_html":"Returns a row containing enough information to uniquely identify the database object specified by catalog OID, object OID and sub-object ID. The returned information is independent of the current server, that is, it could be used to identify an identically named object in another server. \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e identifies the type of database object; \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e are text arrays that together form a reference to the object. These three values can be passed to \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e to obtain the internal address of the object.","description_zh":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。type 标识数据库对象的类型；object_names 和 object_args 是 text 数组，共同构成对该对象的引用。将这三个值传给 pg_get_object_address 可以获得对象的内部地址。","description_zh_html":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。\u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e 标识数据库对象的类型；\u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e 是 text 数组，共同构成对该对象的引用。将这三个值传给 \u003ccode class=\"function\"\u003epg_get_object_address\u003c/code\u003e 可以获得对象的内部地址。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_identify_object_as_address\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eclassid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobjsubid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext[]\u003c/code\u003e )","returns":"record","text":"pg_identify_object_as_address ( classid oid, objid oid, objsubid integer ) → record ( type text, object_names text[], object_args text[] )","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}