I've created a few new UDTs in PostgreSQL. However, now I have two problems:
- how to see which UDTs have been defined?
- how to see the columns defined within these UDTs?
Unfortunately, I couldn't find anything on that in the PostgreSQL documentation.
catalogspostgresqluser-defined-type
I've created a few new UDTs in PostgreSQL. However, now I have two problems:
Unfortunately, I couldn't find anything on that in the PostgreSQL documentation.
Best Answer
Does this get you started?
In psql you can
\set ECHO_HIDDEN on
to make psql show you the queries used to generate the output of the\d...
commands. I've found these queries to be very useful as a starting point when digging metadata out of databases.Update: 2019-12-16
For composite types, the columns metadata can be determined using something like the following: