Apache DB | DdlUtils | for

Home

Section |
apache.org > db > ddlutils | PDF
## PostgreSQL DdlUtils supports PostgreSQL version 7.2.8 and newer. SQL syntax details and supported datatypes are described in the Manual. Platform identifier: PostgreSql Recognized JDBC driver: org.postgresql.Driver Recognized JDBC sub protocol: jdbc:postgresql
The database supports SQL comments | yes
The database supports delimited identifiers | yes
The database's maximum identifier length | 31
The database supports default values for LONG types | yes
DdlUtils uses sequences for identity columns | yes
The database supports non-primary key columns as identity columns | yes
The database allows INSERT/UPDATE statements to set values for identity columns | yes
DdlUtils can read back the auto-generated value of an identity column | yes
The database supports non-unique indices | yes
DdlUtils can create a database via JDBC | yes
DdlUtils can drop a database via JDBC | yes
JDBC Type | Database Type | Additional comments
--- | --- | ---
ARRAY | BYTEA | Will be read back as LONGVARBINARY
BIGINT | BIGINT |
BINARY | BYTEA | Will be read back as LONGVARBINARY
BIT | BOOLEAN |
BLOB | BYTEA |
BOOLEAN | BOOLEAN | Will be read back as BIT
CHAR | CHAR |
CLOB | TEXT | Will be read back as LONGVARCHAR
DATALINK | BYTEA | Will be read back as LONGVARBINARY
DATE | DATE |
DECIMAL | NUMERIC | Will be read back as NUMERIC
DISTINCT | BYTEA | Will be read back as LONGVARBINARY
DOUBLE | DOUBLE PRECISION |
FLOAT | DOUBLE PRECISION | Will be read back as DOUBLE
INTEGER | INTEGER |
JAVA_OBJECT | BYTEA | Will be read back as LONGVARBINARY
LONGVARBINARY | BYTEA |
LONGVARCHAR | TEXT |
NULL | BYTEA | Will be read back as LONGVARBINARY
NUMERIC | NUMERIC |
OTHER | BYTEA | Will be read back as LONGVARBINARY
REAL | REAL |
REF | BYTEA | Will be read back as LONGVARBINARY
SMALLINT | SMALLINT |
STRUCT | BYTEA | Will be read back as LONGVARBINARY
TIME | TIME |
TIMESTAMP | TIMESTAMP |
TINYINT | SMALLINT | Will be read back as SMALLINT
VARBINARY | BYTEA | Will be read back as LONGVARBINARY
VARCHAR | VARCHAR |