How to create enums using pgAdmin?

postgresql enums pgadmin
AAgg picture AAgg · Sep 28, 2014 · Viewed 9.1k times · Source

I am using pgAdmin ver 1.18.1 for PostgreSQL 9.3. I want to create an enum but could not find any option in the GUI to do the same. Tried searching pgAdmin documentation as well but could not find anything.

Does pgAdmin not support creation of enums? If yes, then why and how it should be done then?

Thanks.

Answer

Greg picture Greg · Sep 28, 2014

I fired up a copy of pgadmin and noticed what you said, I couldn't see my 'types'. If you pull down the main menu and go to preferences, then scroll down until you see Type, then check the box and refresh you screen, then types become visible.

Related questions

Adding a new value to an existing ENUM Type

I have a table column that uses an enum type. I wish to update that enum type to have an additional possible value. I don't want to delete any existing values, just add the new value. What is the simplest …

Read More
SQL query to get all values a enum can have

Postgresql got enum support some time ago. CREATE TYPE myenum AS ENUM ( 'value1', 'value2', ); How do I get all values specified in the enum with a query?

Read More
How to delete an enum type value in postgres?

How do I delete an enum type value that I created in postgresql? create type admin_level1 as enum('classifier', 'moderator', 'god'); E.g. I want to remove moderator from the list. I can't seem to find anything on the …

Read More