# JDBC to PostgreSQL mappings.
#
# See http://www.postgresql.org/idocs/index.php?datatype.html for more
# information on PostgreSQL data types.

BIT = BOOLEAN
TINYINT = INT2
SMALLINT = INT2
INTEGER = INTEGER
BIGINT = INT8
FLOAT = FLOAT
REAL = FLOAT
BOOLEANCHAR = CHAR
BOOLEANINT = INT2

DOUBLE = DOUBLE PRECISION
# numeric(precision, scale) / decimal(precision, scale)
NUMERIC = NUMERIC
DECIMAL = DECIMAL
CHAR = CHAR
# just use TEXT for everything
VARCHAR = TEXT
LONGVARCHAR = TEXT
DATE = DATE
TIME = TIME
TIMESTAMP = TIMESTAMP
BINARY = BYTEA
VARBINARY = BYTEA
LONGVARBINARY = BYTEA
NULL =
OTHER =
JAVA_OBJECT =
DISTINCT =
STRUCT =
ARRAY =
BLOB = OID
CLOB = TEXT
REF =

AUTOINCREMENT = SERIAL
NOTNULL = NOT NULL