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?

You need to enable the display for the "Browser Tool": pgadmin.org/docs/1.20/options-browser.html — user330315
– user330315, Commented Feb 13, 2015 at 7:09
@a_horse_with_no_name, Yeah! Got it. But is there any script to details? — MAK
– MAK, Commented Feb 13, 2015 at 7:22

vitvly · Accepted Answer · 2015-02-13 16:07:24Z

2

Use pg_type system catalog:

SELECT * FROM PG_TYPE WHERE typname='t1';

answered Feb 13, 2015 at 16:07

vitvly

3,6884 gold badges34 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1