pg_relation_filepath

Returns the entire file path name (relative to the database cluster's data directory, PGDATA) of the relation.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: admin
group label: 系统管理函数
lang: en
layout: table-new
pages: functions-admin.html
prose only: false

Definition PG 18

Returns the entire file path name (relative to the database cluster's data directory, PGDATA) of the relation.

Signatures and overloads

pg_relation_filepath ( relation regclass ) → text → text

Returns the entire file path name (relative to the database cluster's data directory, PGDATA) of the relation.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","version":"18.7"},{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"830e894d29fec30b7c350c915fcaed4a63b24d57f2c96150bf25fa07fb43849c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:1a10e9631d77881e7eca8b66b397b0b4b2f3c9e865fb506e5bd312de2408c2ec

Text language: en · wiki-repair-20261023:1a10e9631d77881e7eca8b66b397b0b4b2f3c9e865fb506e5bd312de2408c2ec