{"Entry":{"collection":"func","key":"pg-filenode-relation","name":"pg_filenode_relation","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.3","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.4"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"a757652c7c160ebdaec9c634a10f4e2f25ea83f9e633f0ef7f51e241c309e929","first_version":"9.4","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.511231+08:00","last_version":"20","name":"pg_filenode_relation","name_key":"pg_filenode_relation","position":29040,"present_in":["9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_filenode_relation ( tablespace oid, filenode oid ) → regclass","signature_count":1,"slug":"pg-filenode-relation","source_rev":"b7bd9cda","summary":"Returns a relation's OID given the tablespace OID and filenode it is stored under.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-filenode-relation","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-filenode-relation","SourceRevision":"b7bd9cda","Facts":{"description":"Returns a relation's OID given the tablespace OID and filenode it is stored under. This is essentially the inverse mapping of pg_relation_filepath. For a relation in the database's default tablespace, the tablespace can be specified as zero. Returns NULL if no relation in the current database is associated with the given values, or if dealing with a temporary relation.","description_html":"Returns a relation's OID given the tablespace OID and filenode it is stored under. This is essentially the inverse mapping of \u003ccode class=\"function\"\u003epg_relation_filepath\u003c/code\u003e. For a relation in the database's default tablespace, the tablespace can be specified as zero. Returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e if no relation in the current database is associated with the given values, or if dealing with a temporary relation.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADMIN-DBLOCATION","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Returns a relation's OID given the tablespace OID and filenode it is stored under. This is essentially the inverse mapping of pg_relation_filepath. For a relation in the database's default tablespace, the tablespace can be specified as zero. Returns NULL if no relation in the current database is associated with the given values, or if dealing with a temporary relation.","description_html":"Returns a relation's OID given the tablespace OID and filenode it is stored under. This is essentially the inverse mapping of \u003ccode class=\"function\"\u003epg_relation_filepath\u003c/code\u003e. For a relation in the database's default tablespace, the tablespace can be specified as zero. Returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e if no relation in the current database is associated with the given values, or if dealing with a temporary relation.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_filenode_relation\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efilenode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eregclass\u003c/code\u003e","returns":"regclass","text":"pg_filenode_relation ( tablespace oid, filenode oid ) → regclass","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-DBLOCATION","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-filenode-relation","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_filenode_relation","Summary":"根据关系所在表空间的 OID 和文件节点返回该关系的 OID。这本质上是pg_relation_filepath的反向映射。对于数据库默认表空间中的关系，表空间可以指定为 0。如果当前数据库中没有与给定值关联的关系，或者该关系是临时关系，则返回NULL。","BodyHTML":"根据关系所在表空间的 OID 和文件节点返回该关系的 OID。这本质上是\u003ccode\u003epg_relation_filepath\u003c/code\u003e的反向映射。对于数据库默认表空间中的关系，表空间可以指定为 0。如果当前数据库中没有与给定值关联的关系，或者该关系是临时关系，则返回\u003ccode\u003eNULL\u003c/code\u003e。\u003cpre\u003epg_filenode_relation ( tablespace oid, filenode oid ) → regclass\u003c/pre\u003e根据关系所在表空间的 OID 和文件节点返回该关系的 OID。这本质上是\u003ccode\u003epg_relation_filepath\u003c/code\u003e的反向映射。对于数据库默认表空间中的关系，表空间可以指定为 0。如果当前数据库中没有与给定值关联的关系，或者该关系是临时关系，则返回\u003ccode\u003eNULL\u003c/code\u003e。","SourceRevision":"ca936764","ContentHash":"e2887b01098e04c2d37f34a5b261c735c6ab72794a5e5401a8da0be67a98f502","Payload":{"description_zh":"根据关系所在表空间的 OID 和文件节点返回该关系的 OID。这本质上是pg_relation_filepath的反向映射。对于数据库默认表空间中的关系，表空间可以指定为 0。如果当前数据库中没有与给定值关联的关系，或者该关系是临时关系，则返回NULL。","description_zh_html":"根据关系所在表空间的 OID 和文件节点返回该关系的 OID。这本质上是\u003ccode class=\"function\"\u003epg_relation_filepath\u003c/code\u003e的反向映射。对于数据库默认表空间中的关系，表空间可以指定为 0。如果当前数据库中没有与给定值关联的关系，或者该关系是临时关系，则返回\u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","signatures":[{"description_zh":"根据关系所在表空间的 OID 和文件节点返回该关系的 OID。这本质上是pg_relation_filepath的反向映射。对于数据库默认表空间中的关系，表空间可以指定为 0。如果当前数据库中没有与给定值关联的关系，或者该关系是临时关系，则返回NULL。","description_zh_html":"根据关系所在表空间的 OID 和文件节点返回该关系的 OID。这本质上是\u003ccode class=\"function\"\u003epg_relation_filepath\u003c/code\u003e的反向映射。对于数据库默认表空间中的关系，表空间可以指定为 0。如果当前数据库中没有与给定值关联的关系，或者该关系是临时关系，则返回\u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。","returns":"regclass","text":"pg_filenode_relation ( tablespace oid, filenode oid ) → regclass","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"2b91b179dd321e628a55a0b464c10e90db237f873d31e8f4c026a546b0aaeabd","Text":"pg_filenode_relation ( tablespace oid, filenode oid ) → regclass","Returns":"regclass","Payload":{"description":"Returns a relation's OID given the tablespace OID and filenode it is stored under. This is essentially the inverse mapping of pg_relation_filepath. For a relation in the database's default tablespace, the tablespace can be specified as zero. Returns NULL if no relation in the current database is associated with the given values, or if dealing with a temporary relation.","description_html":"Returns a relation's OID given the tablespace OID and filenode it is stored under. This is essentially the inverse mapping of \u003ccode class=\"function\"\u003epg_relation_filepath\u003c/code\u003e. For a relation in the database's default tablespace, the tablespace can be specified as zero. Returns \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e if no relation in the current database is associated with the given values, or if dealing with a temporary relation.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_filenode_relation\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efilenode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eregclass\u003c/code\u003e","returns":"regclass","text":"pg_filenode_relation ( tablespace oid, filenode oid ) → regclass","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}