Menu
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.
973
PostgreSQL enum is the data type that was used in PostgreSQL to stored same type of values in column field, we can store same type of values using enum.
Enumerated (enum) types are data types that comprise a static, ordered set of values. They are equivalent to the enum types supported in a number of programming languages. An example of an enum type might be the days of the week, or a set of status values for a piece of data.
Postgres stores Enums in the pg_type catalog.
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.
187
Just Create "type" in types option which is located in the schema section.While creating type just select enumeration type and fill your value in label
30
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
