{"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","derived_content_hash":"a990de268d94192706f34b7811808d8149aa2b4257b2199e30bbd0a814b7bfc0","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:db10604c6f69882c1638a62625f64bcca800636c3721644ca63b9d05766a6c70","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"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"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"fefdcde8aa3e58d45d422d2bb1c15bad84e6fec51daa76b733fda4a252d724aa","repair":"wiki-repair-20261023"},"signature":"pg_filenode_relation ( tablespace oid, filenode oid ) → regclass","signature_count":1,"slug":"pg-filenode-relation","source_rev":"wiki-repair-20261023:db10604c6f69882c1638a62625f64bcca800636c3721644ca63b9d05766a6c70","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":"wiki-repair-20261023:db10604c6f69882c1638a62625f64bcca800636c3721644ca63b9d05766a6c70","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":"根据关系所在表空间的 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。","doc":{"anchor":"FUNCTIONS-ADMIN-DBLOCATION","file":"functions-admin.html","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","version":"18.7"},{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"830e894d29fec30b7c350c915fcaed4a63b24d57f2c96150bf25fa07fb43849c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"admin","group_label":"系统管理函数","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":"根据关系所在表空间的 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。","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":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-admin.html","sha256":"b4fab9daceb7883fd75b32b6eb5398f2bbbfbbed5c83d1b2bf99cc8d842cdaf7"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-DBLOCATION","file":"functions-admin.html","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-filenode-relation","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_filenode_relation","Summary":"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.","BodyHTML":"Returns a relation\u0026#39;s OID given the tablespace OID and filenode it is stored under. This is essentially the inverse mapping of \u003ccode\u003epg_relation_filepath\u003c/code\u003e. For a relation in the database\u0026#39;s default tablespace, the tablespace can be specified as zero. Returns \u003ccode\u003eNULL\u003c/code\u003e if no relation in the current database is associated with the given values, or if dealing with a temporary relation.","SourceRevision":"wiki-repair-20261023:db10604c6f69882c1638a62625f64bcca800636c3721644ca63b9d05766a6c70","ContentHash":"3d796e295b5faf5a66308a94b4fa595a5ee972fd55f50c376b3e457099d7d89e","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.","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":"根据关系所在表空间的 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。","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":"same-version-manual"}]}},"RequestedLocale":"en","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":"根据关系所在表空间的 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。","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":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}