↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Administration Functions

pg_relation_filepath

Read the PG 18 manual

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

Reading PG 18current·documented in 18 of 27 versions, 9.0 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

pg_relation_filepath ( relation regclass ) → text
Returns the entire file path name (relative to the database cluster's data directory, PGDATA) of the relation.
Version history 3
  1. 12 → 13 changed
  2. 9.0 → 9.1 changed
  3. 8.4 → 9.0 added

Definition snapshot: b7bd9cda · English manual source