enum data type for liquibase

postgresql liquibase liquid-layout
Ali Taha Ali Mahboub picture Ali Taha Ali Mahboub · Feb 27, 2011 · Viewed 14k times · Source

I'm currently working on a liquibase.xml file to create table table_a. One of my fields is <column name="state" type="ENUM('yes','no')"> I'm using postgresql as my DBMS. is there anything like enum data type? I've read in this like http://wiki.postgresql.org/wiki/Enum

that postgresql doesn't have such data type. CREATE TYPE function is used to create this data type. I still don't know how to make it in liquibase though.

Any suggestions?

Answer

a_horse_with_no_name picture a_horse_with_no_name · Feb 27, 2011

Well of course PostgreSQL has an enum type (which is clearly documented in the link you have shown and the manual).

I don't think Liquibase "natively" supports enums for PostgreSQL, but you should be able to achieve it with a custom SQL:

<changeSet id="1" author="Arthur">
  <sql>CREATE TYPE my_state AS ENUM ('yes','no')</sql>
  <table name="foo">
    <column name="state" type="my_state"/>
  </table>
</changeSet>

For a simple yes/no column, I'd actually use the boolean type instead of an enum

Related questions

Liquibase create Schema for postgres

I'm using Dropwizard (1.0.0) and Liquibase to create a database if it's not existing. Problem here is that I'm using a different Postgres schema (not public). It seems like Liquibase is not able to create this schema before is it? I …

Read More
Cannot find database driver: org.postgresql.Driver

Im trying to change a project a bit, by upgrading it with Liquibase. Its a Java EE project. So im using the liquibase-maven-plugin. So far i have in my pom.xml: <plugin> <groupId>org.liquibase</…

Read More
How to add new column with default value from existing column in Liquibase

I'm using Postgres DB and for migration I'm using Liquibase. I have an ORDERS table with the following columns: ID | DATE | NAME | CREATOR | ... I need to add a new column which will hold the user who has last modified the …

Read More