↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / System Information Functions And Operators

pg_get_partkeydef

Read the PG 18 manual

Reconstructs the definition of a partitioned table's partition key, in the form it would have in the PARTITION BY clause of CREATE TABLE.

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

Signatures & examples

pg_get_partkeydef ( table oid ) → text
Reconstructs the definition of a partitioned table's partition key, in the form it would have in the PARTITION BY clause of CREATE TABLE. (This is a decompiled reconstruction, not the original text of the command.)
Version history 1
  1. 15 → 16 added

Definition snapshot: b7bd9cda · English manual source