↑↓ 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_filenode

Read the PG 18 manual

Returns the “filenode” number currently assigned to the specified relation.

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

Signatures & examples

pg_relation_filenode ( relation regclass ) → oid
Returns the “filenode” number currently assigned to the specified relation. The filenode is the base component of the file name(s) used for the relation (see Section 66.1 for more information). For most relations the result is the same as pg_class.relfilenode, but for certain system catalogs relfilenode is zero and this function must be used to get the correct value. The function returns NULL if passed a relation that does not have storage, such as a view.
Version history 7
  1. 17 → 18 changed
  2. 16 → 17 changed
  3. 14 → 15 changed
  4. 13 → 14 changed
  5. 12 → 13 changed
  6. 9.0 → 9.1 changed
  7. 8.4 → 9.0 added

Definition snapshot: b7bd9cda · English manual source