H2Database:MODE=PostgreSQL: doesn't support ENUM type <p>I want to use H2 with PostgreSQL dialect.</p> <p>My H2 version: </p> <pre><code>"com.h2database" % "h2" % "1.4.190" </code></pre> <p>This is my config H2:</p> <pre><code>jdbc.url=jdbc:h2:mem:test;MODE=PostgreSQL;DB_CLOSE_DELAY=-1 jdbc.driver_class=org.h2.Driver jdbc.username=sa jdbc.password="" </code></pre> <p>This is my SQL-statement:</p> <pre><code>create type myEnum as enum ('one', 'two', 'three'); </code></pre> <p>When I try to execute it (with simple scala-JDBC), the following exception is thrown:</p> <pre><code>Unknown data type: "ENUM"; SQL statement: </code></pre> <p>From official site <a href="http://www.h2database.com/html/roadmap.html?highlight=enum&amp;search=enum#firstFound" rel="nofollow">http://www.h2database.com/html/roadmap.html?highlight=enum&amp;search=enum#firstFound</a>: </p> <pre><code>Support ENUM data type (see MySQL, PostgreSQL, MS SQL Server, maybe others). </code></pre> <p>Can anybody tell me what I do wrong?</p>