{"Entry":{"collection":"func","key":"pg-relation-filenode","name":"pg_relation_filenode","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.0"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"9.1"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"13","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"14"},{"descriptions_changed":true,"doc_overhaul":false,"from":"14","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"15"},{"descriptions_changed":true,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"17"},{"descriptions_changed":true,"doc_overhaul":false,"from":"17","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"18"}],"content_hash":"717e58320defe14370d8821c98798294bfd0703385d2b14a532cd84e8b27644d","first_version":"9.0","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.611363+08:00","last_version":"20","name":"pg_relation_filenode","name_key":"pg_relation_filenode","position":29076,"present_in":["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":"pg_relation_filenode ( relation regclass ) → oid","signature_count":1,"slug":"pg-relation-filenode","source_rev":"b7bd9cda","summary":"Returns the “filenode” number currently assigned to the specified relation.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-relation-filenode","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-relation-filenode","SourceRevision":"b7bd9cda","Facts":{"description":"Returns the “filenode” number currently assigned to the specified relation. The filenode is the base component of the file name(s) used for the relation (see Section 66.1 for more information). For most relations the result is the same as pg_class.relfilenode, but for certain system catalogs relfilenode is zero and this function must be used to get the correct value. The function returns NULL if passed a relation that does not have storage, such as a view.","description_html":"Returns the \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003efilenode\u003c/span\u003e”\u003c/span\u003e number currently assigned to the specified relation. The filenode is the base component of the file name(s) used for the relation (see \u003ca href=\"/docs/18/storage-file-layout.html\" title=\"66.1. Database File Layout\"\u003eSection 66.1\u003c/a\u003e for more information). For most relations the result is the same as \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e.\u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e, but for certain system catalogs \u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e is zero and this function must be used to get the correct value. The function returns NULL if passed a relation that does not have storage, such as a view.","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 the “filenode” number currently assigned to the specified relation. The filenode is the base component of the file name(s) used for the relation (see Section 66.1 for more information). For most relations the result is the same as pg_class.relfilenode, but for certain system catalogs relfilenode is zero and this function must be used to get the correct value. The function returns NULL if passed a relation that does not have storage, such as a view.","description_html":"Returns the \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003efilenode\u003c/span\u003e”\u003c/span\u003e number currently assigned to the specified relation. The filenode is the base component of the file name(s) used for the relation (see \u003ca href=\"/docs/18/storage-file-layout.html\" title=\"66.1. Database File Layout\"\u003eSection 66.1\u003c/a\u003e for more information). For most relations the result is the same as \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e.\u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e, but for certain system catalogs \u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e is zero and this function must be used to get the correct value. The function returns NULL if passed a relation that does not have storage, such as a view.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_relation_filenode\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003erelation\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eoid\u003c/code\u003e","returns":"oid","text":"pg_relation_filenode ( relation regclass ) → oid","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-DBLOCATION","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-relation-filenode","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_relation_filenode","Summary":"返回当前分配给指定关系的“文件节点”编号。文件节点是关系所用文件名的基本组成部分（更多信息见第 66.1 节）。对于大多数关系，结果与 pg_class.relfilenode相同；但某些系统目录的 relfilenode为零，必须使用此函数获取正确值。如果传入的关系没有存储空间（例如视图），函数返回 NULL。","BodyHTML":"返回当前分配给指定关系的\u003cspan\u003e“\u003cspan\u003e文件节点\u003c/span\u003e”\u003c/span\u003e编号。文件节点是关系所用文件名的基本组成部分（更多信息见\u003ca href=\"/docs/18/storage-file-layout.html\" rel=\"nofollow\"\u003e第 66.1 节\u003c/a\u003e）。对于大多数关系，结果与 \u003ccode\u003epg_class\u003c/code\u003e.\u003ccode\u003erelfilenode\u003c/code\u003e相同；但某些系统目录的 \u003ccode\u003erelfilenode\u003c/code\u003e为零，必须使用此函数获取正确值。如果传入的关系没有存储空间（例如视图），函数返回 NULL。\u003cpre\u003epg_relation_filenode ( relation regclass ) → oid\u003c/pre\u003e返回当前分配给指定关系的\u003cspan\u003e“\u003cspan\u003e文件节点\u003c/span\u003e”\u003c/span\u003e编号。文件节点是关系所用文件名的基本组成部分（更多信息见\u003ca href=\"/docs/18/storage-file-layout.html\" rel=\"nofollow\"\u003e第 66.1 节\u003c/a\u003e）。对于大多数关系，结果与 \u003ccode\u003epg_class\u003c/code\u003e.\u003ccode\u003erelfilenode\u003c/code\u003e相同；但某些系统目录的 \u003ccode\u003erelfilenode\u003c/code\u003e为零，必须使用此函数获取正确值。如果传入的关系没有存储空间（例如视图），函数返回 NULL。","SourceRevision":"ca936764","ContentHash":"5b889aa735c80188b5395998b910d669f4fa424646f9a7fc8ebffb0e22b5e2b5","Payload":{"description_zh":"返回当前分配给指定关系的“文件节点”编号。文件节点是关系所用文件名的基本组成部分（更多信息见第 66.1 节）。对于大多数关系，结果与 pg_class.relfilenode相同；但某些系统目录的 relfilenode为零，必须使用此函数获取正确值。如果传入的关系没有存储空间（例如视图），函数返回 NULL。","description_zh_html":"返回当前分配给指定关系的\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e文件节点\u003c/span\u003e”\u003c/span\u003e编号。文件节点是关系所用文件名的基本组成部分（更多信息见\u003ca href=\"/docs/18/storage-file-layout.html\" title=\"66.1. 数据库文件布局\"\u003e第 66.1 节\u003c/a\u003e）。对于大多数关系，结果与 \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e.\u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e相同；但某些系统目录的 \u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e为零，必须使用此函数获取正确值。如果传入的关系没有存储空间（例如视图），函数返回 NULL。","signatures":[{"description_zh":"返回当前分配给指定关系的“文件节点”编号。文件节点是关系所用文件名的基本组成部分（更多信息见第 66.1 节）。对于大多数关系，结果与 pg_class.relfilenode相同；但某些系统目录的 relfilenode为零，必须使用此函数获取正确值。如果传入的关系没有存储空间（例如视图），函数返回 NULL。","description_zh_html":"返回当前分配给指定关系的\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e文件节点\u003c/span\u003e”\u003c/span\u003e编号。文件节点是关系所用文件名的基本组成部分（更多信息见\u003ca href=\"/docs/18/storage-file-layout.html\" title=\"66.1. 数据库文件布局\"\u003e第 66.1 节\u003c/a\u003e）。对于大多数关系，结果与 \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e.\u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e相同；但某些系统目录的 \u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e为零，必须使用此函数获取正确值。如果传入的关系没有存储空间（例如视图），函数返回 NULL。","returns":"oid","text":"pg_relation_filenode ( relation regclass ) → oid","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"c112e116181117b8199f7c30cef5d2a687a488844f42b0a8e5904a10a56c62dc","Text":"pg_relation_filenode ( relation regclass ) → oid","Returns":"oid","Payload":{"description":"Returns the “filenode” number currently assigned to the specified relation. The filenode is the base component of the file name(s) used for the relation (see Section 66.1 for more information). For most relations the result is the same as pg_class.relfilenode, but for certain system catalogs relfilenode is zero and this function must be used to get the correct value. The function returns NULL if passed a relation that does not have storage, such as a view.","description_html":"Returns the \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003efilenode\u003c/span\u003e”\u003c/span\u003e number currently assigned to the specified relation. The filenode is the base component of the file name(s) used for the relation (see \u003ca href=\"/docs/18/storage-file-layout.html\" title=\"66.1. Database File Layout\"\u003eSection 66.1\u003c/a\u003e for more information). For most relations the result is the same as \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e.\u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e, but for certain system catalogs \u003ccode class=\"structfield\"\u003erelfilenode\u003c/code\u003e is zero and this function must be used to get the correct value. The function returns NULL if passed a relation that does not have storage, such as a view.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_relation_filenode\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003erelation\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eoid\u003c/code\u003e","returns":"oid","text":"pg_relation_filenode ( relation regclass ) → oid","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}