Home > Documentation > DB2 to PostgreSQL

IBM DB2 to PostgreSQL Types Mapping

[DB2 to Postgres Converter]  [About Migration]  [Built-in Functions]

IBM DB2 and PostgreSQL data types are not matched directly. Most of them are equal while others are not. When migrating database from DB2 to PostgreSQL it is important to take care about safe types mapping according to the table below:

IBM DB2 PostgreSQL
BIGINT BIGINT
BLOB(n) BYTEA
CHAR(n), CHARACTER(n) CHAR(n)
CHARACTER VARYING(n), VARCHAR(n) VARCHAR(n)
CLOB(n) TEXT
DATE DATE
DBCLOB(n) TEXT
DECFLOAT(16 | 34) FLOAT
DECIMAL(p,s) DECIMAL(p,s)
DOUBLE PRECISION DOUBLE PRECISION
FLOAT(p) DOUBLE PRECISION
GRAPHIC(n) CHAR(n)
INTEGER INTEGER
NUMERIC(p,s) NUMERIC(p,s)
NCHAR(n) CHAR(n
NCHAR VARYING(n), NVARCHAR(n) VARCHAR(n
NVARCHAR(n) VARCHAR(n)
REAL REAL
SMALLINT SMALLINT
TIME TIME(0)
TIMESTAMP(p) TIMESTAMP(p)