The pg_typeof() function allows you to retrieve the data type of any given value. It returns a string literal corresponding to the expression type.
The syntax of the pg_typeof() function is:
Here, any represents any value you want to determine the data type.
This case shows a basic example with a numeric value:
It will return its data type, which is “integer”.
Here, we will use a string value as an input:
It will return its data type, which is “text”.
Another example is using an interval input:
It will return its data type in string literal.
Suppose you have a sample table and want to use pg_typeof() to retrieve their data types.
1) Create the table and insert some data into the table.
2) Now, use pg_typeof() to determine the data types of the event_time and description columns for each row.
3) The result will show that the data type of the event_time column is a timestamp, and the data type of the description column is text: