types

From: Mark Hage <m(dot)c(dot)hage(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: types
Date: 2009-05-12 15:02:29
Message-ID: 43232d140905120802o3771004dic541088a077abce@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: types at 2009-07-06 17:44:42 from Andreas Wenk

Browse pgsql-novice by date

  From Date Subject
Next Message James Bowkett 2009-05-12 15:40:35 pg_dump on 64-bit windows 2003 server
Previous Message David Garamond 2009-05-12 08:08:16 Array: restricting NULL elements?