Jump to content

Create Type As Enum In Postgresql


primagozer

Recommended Posts

I would like to use the ENUM data type in a Postgresql database. Such a type must be created first with the CREATE TYPE ... AS ENUM ('...', '...') command. It is possible to do that in phpPgAdmin, but for that the config file for phpPgAdmin must have the "advanced objects" enabled.

See for more info this:

 

http://stackoverflow.com/questions/5389206/how-do-i-create-and-edit-composite-types-in-phppgadmin

 

Since there is no Types section under Schemas, I presume in the config file of phpPgAdmin the "advanced objects" have not been enabled. Did I understand this correctly, and if so, could it be enabled? Thanks for your help!

 

I am on Johnny, by the way.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...