Contents
pg_relation_filepath()
A function for obtaining the filepath of a relation
pg_relation_filepath() is a system function for obtaining the filepath of a relation, relative to the data directory.
pg_relation_filepath() was added in PostgreSQL 9.0.
Change history
- PostgreSQL 9.0
- added (commit b9b8831a)
Examples
Basic usage example for pg_relation_filepath():
postgres=# SELECT pg_relation_filepath('foo');
pg_relation_filepath
----------------------
base/13832/16499
(1 row)
See filenode for further examples.
References
- PostgreSQL documentation: Database Object Location Functions