Functions / System Information Functions And Operators

pg_get_expr

Decompiles the internal form of an expression stored in the system catalogs, such as the default value for a column.

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

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 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

Signatures & examples

pg_get_expr ( expr pg_node_tree, relation oid [, pretty boolean ] ) → text

Decompiles the internal form of an expression stored in the system catalogs, such as the default value for a column. If the expression might contain Vars, specify the OID of the relation they refer to as the second parameter; if no Vars are expected, passing zero is sufficient.

Version history 4

12 → 13 changed
9.0 → 9.1 changed
7.4 → 8.0 changed
7.3 → 7.4 added

Definition snapshot: b7bd9cda · English manual source