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
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