I need to know the column-type names of a table, and so far i'm using this query :
SELECT column_name as name,
data_type as type
WHERE table_name = 'MY_TABLE';
I cannot test this right now, but according to the documentation for
Data type of the column, if it is a built-in type, or ARRAY if it is some array (in that case, see the view element_types), else USER-DEFINED (in that case, the type is identified in udt_name and associated columns). If the column is based on a domain, this column refers to the type underlying the domain (and the domain is identified in domain_name and associated columns).
So maybe the column
udt_name contains what you want.