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

Examples

postgres=# SELECT pg_relation_filenode('foo');
 pg_relation_filenode 
----------------------
                16499
(1 row)

See filenode for further examples.

Categories

Data directory, System function

See also

filenode, pg_filenode_relation(), pg_relation_filepath()