data_type and UDT_name in postgresql

Question

Can anyone help me to find different data_type and corresponding udt_name in postgresql. I tried searching in Internet but no luck. Any reference where I can find it.

Answer 1

try this.

select data_type,udt_name from information_schema.columns ;