pg_relation_filenode()
A function for obtaining the filenode number of a relation
pg_relation_filenode() is a system function for obtaining the filenode number of a relation with the specified OID or name.
pg_relation_filenode() was added in PostgreSQL 9.0.
Change history
- PostgreSQL 9.0
- added (commit b9b8831a)
Examples
postgres=# SELECT pg_relation_filenode('foo');
pg_relation_filenode
----------------------
16499
(1 row)
See filenode for further examples.
References
- PostgreSQL documentation: Database Object Location Functions
Useful links
- The mapping of oid and relfilenode in PG - January 2021 blog article by High Go Software