Contents

pg_filenode_relation()

A function for finding the relation associated with a tablespace and filenode

pg_filenode_relation() is a system function which finds the relation associated with a given tablespace and filenode.

pg_filenode_relation() was added in PostgreSQL 9.4.

Usage

pg_filenode_relation ( tablespace oid, filenode oid ) → regclass

Change history

Examples

Basic usage example for pg_filenode_relation():

postgres=# SELECT pg_filenode_relation(0, 16499);
 pg_filenode_relation 
----------------------
 foo
(1 row)

See filenode for a fuller example.

Categories

Data directory, PostgreSQL internals, System function

See also

filenode, pg_relation_filenode(), pg_relation_filepath()