Unable to create column with type "TIMESTAMP WITHOUT TIME ZONE" in PostgreSQL

Question

when I tried to create a column with the data type "TIMESTAMP WITHOUT TIME ZONE" in postgresql it is always created in the database as "TIMESTAMP WITH TIME ZONE", so are there any workarounds or solutions to this problem?

<addColumn tableName="myTable"> <column name="date_added" type="TIMESTAMP WITHOUT TIME ZONE"> <constraints nullable="false" /> </column> </addColumn> 

btw, this question is on jira: http://liquibase.jira.com/browse/CORE-877

Answer 1

Read this page http://www.liquibase.org/documentation/sql_format.html . just manually enter the required SQL exactly the way you want if you use the SQL format with Liquibase.

Answer 2

Instead of using a tag and completely switching from XML to sql, you can modify the resulting generated SQL using a tag that is valid for the entire set of changes: http://www.liquibase.org/documentation/modify_sql.html

for example, in your case you will have the following:

 <modifySql dbms="postgresql"> <replace replace="WITH" with="WITHOUT"/> </modifySql> 

Answer 3

You can use <sql> to create the exact SQL you need if Liquibase creates the wrong SQL for you.

Answer 4

In addition to @magomarcelo, you can also write modifysql as YAML. The following example ignores unsigned in postgresql:

 - modifySql: dbms: postgresql replace: replace: unsigned with: default 0