Question : how to get information about data types in postgreSQL
Answered by : mazeltov27
-- 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 = '______';
Source : | Last Update : Tue, 05 Apr 22