Home
 

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