How To Get Information About Data Types In Postgresql

[Solved] How To Get Information About Data Types In Postgresql | Sql - Code Explorer | yomemimo.com
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

Answers related to how to get information about data types in postgresql

Code Explorer Popular Question For Sql