PostgreSQL Enums

gistfile1.txt

- To rename a data type:

ALTER TYPE electronic_mail RENAME TO email;

- To change the owner of the type email to joe:

ALTER TYPE email OWNER TO joe;

- To change the schema of the type email to customers:

ALTER TYPE email SET SCHEMA customers;

- To add a new attribute to a type:

ALTER TYPE compfoo ADD ATTRIBUTE f3 int;

- To add a new value to an enum type in a particular sort position:

ALTER TYPE colors ADD VALUE 'orange' AFTER 'red';

- Fetch an enum values (as an array):

SELECT enum_range(NULL::myenum)

- Fetch an enum values (one value per record):

SELECT unnest(enum_range(NULL::myenum))