types - Mailing list pgsql-novice

From Mark Hage
Subject types
Date
Msg-id 43232d140905120802o3771004dic541088a077abce@mail.gmail.com
Whole thread Raw
Responses Re: types
List pgsql-novice
Hi,

I'm new to postgresql, but do have some experience in MySQL.

I wanted to create a new enum type and used the command:
CREATE TYPE gender AS ENUM ('male', 'female', 'unknown')

Which returned success.
When I create a new table I can assign the gender type to a column.

But is it possible to see (and manage) the types I created?
I use pgAdmin III.

Thanks.
Mark

pgsql-novice by date:

Previous
From: David Garamond
Date:
Subject: Array: restricting NULL elements?
Next
From: "James Bowkett"
Date:
Subject: pg_dump on 64-bit windows 2003 server