{"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","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"],"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":"b7bd9cda","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":"b7bd9cda","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":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-OBJECT-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 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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-OBJECT-TABLE","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-identify-object-as-address","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_identify_object_as_address","Summary":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。type标识数据库对象的类型；object_names和object_args是 text 数组，共同构成对该对象的引用。将这三个值传给pg_get_object_address可以获得对象的内部地址。","BodyHTML":"返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。\u003cem\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e标识数据库对象的类型；\u003cem\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e和\u003cem\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e是 text 数组，共同构成对该对象的引用。将这三个值传给\u003ccode\u003epg_get_object_address\u003c/code\u003e可以获得对象的内部地址。\u003cpre\u003epg_identify_object_as_address ( classid oid, objid oid, objsubid integer ) → record ( type text, object_names text[], object_args text[] )\u003c/pre\u003e返回一行，其中包含足以唯一标识数据库对象的信息，该对象由系统目录 OID、对象 OID 和子对象 ID 指定。返回的信息与当前服务器无关，也就是说，它也能用于标识另一台服务器上名称相同的对象。\u003cem\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e标识数据库对象的类型；\u003cem\u003e\u003ccode\u003eobject_names\u003c/code\u003e\u003c/em\u003e和\u003cem\u003e\u003ccode\u003eobject_args\u003c/code\u003e\u003c/em\u003e是 text 数组，共同构成对该对象的引用。将这三个值传给\u003ccode\u003epg_get_object_address\u003c/code\u003e可以获得对象的内部地址。","SourceRevision":"ca936764","ContentHash":"43834c25a23afdb0e720bd1affa9344bea394841f41a8f367aae85b7c6311a3d","Payload":{"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可以获得对象的内部地址。","signatures":[{"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可以获得对象的内部地址。","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":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}