↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / System Administration Functions

pg_filenode_relation

Read the PG 18 manual

Returns a relation's OID given the tablespace OID and filenode it is stored under.

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

Signatures & examples

pg_filenode_relation ( tablespace oid, filenode oid ) → regclass
Returns a relation's OID given the tablespace OID and filenode it is stored under. This is essentially the inverse mapping of pg_relation_filepath. For a relation in the database's default tablespace, the tablespace can be specified as zero. Returns NULL if no relation in the current database is associated with the given values, or if dealing with a temporary relation.
Version history 2
  1. 12 → 13 changed
  2. 9.3 → 9.4 added

Definition snapshot: b7bd9cda · English manual source