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
- PostgreSQL 9.4
- added (commit f01d1ae3)
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.
References
- PostgreSQL documentation: Database Object Location Functions