Get created type in PostgreSQL

Question

I am using PostgreSQL 9.3 database.

I want to get the created types stored in the database.

Example:

If I create the types:

create type t1 as
(
  cola varchar,
  colb varchar
);

How can I get the details of them in pgAdmin III?

Answer 1

Use pg_type system catalog:

SELECT * FROM PG_TYPE WHERE typname='t1';