PostgreSQL: find information about user defined types

postgresql user-defined-types system-tables
Antonio F. picture Antonio F. · Aug 8, 2011 · Viewed 7.1k times · Source

Where is information about user-defined types stored?

Are there some tables which contain information about the fields of a user-defined composite type, their names, etc.?

Answer

francs picture francs · Aug 8, 2011

The catalog pg_type stores information about data types. Base types and enum types (scalar types) are created with CREATE TYPE, and domains with CREATE DOMAIN.

More information about pg_type plz visit http://www.postgresql.org/docs/9.0/static/catalog-pg-type.html

Related questions

Check if a user-defined type already exists in PostgreSQL

Say I have created some user-defined types in the DB, i.e. CREATE TYPE abc ... Is it then possible to determine if the user-defined type exists or not? Perhaps, using any of the postgres information tables? The main reason for …

Read More
PostgreSQL: Show tables in PostgreSQL

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Read More
PostgreSQL: How to change PostgreSQL user password?

How do I change the password for PostgreSQL user?

Read More