Functions / System Information Functions And Operators

format_type

Returns the SQL name for a data type that is identified by its type OID and possibly a type modifier.

Reading PG 18current·documented in 23 of 27 versions, 8.0 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

format_type ( type oid, typemod integer ) → text

Returns the SQL name for a data type that is identified by its type OID and possibly a type modifier. Pass NULL for the type modifier if no specific modifier is known.

Version history 2

12 → 13 changed
7.4 → 8.0 added

Definition snapshot: b7bd9cda · English manual source