how to get information about data types in postgreSQL
-- Getting information about user-defined data types
SELECT typename, typecategory
FROM pg_type
WHERE typename = '____';
SELECT column_name, data_type, udt_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = '______';