Functions / System Information Functions And Operators

pg_typeof

Returns the OID of the data type of the value that is passed to it.

Reading PG 18current·documented in 19 of 27 versions, 8.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_typeof ( "any" ) → regtype

Returns the OID of the data type of the value that is passed to it. This can be helpful for troubleshooting or dynamically constructing SQL queries. The function is declared as returning regtype, which is an OID alias type (see Section 8.19); this means that it is the same as an OID for comparison purposes but displays as a type name.

pg_typeof(33) → integer

Version history 2

12 → 13 changed
8.3 → 8.4 added

Definition snapshot: b7bd9cda · English manual source