This is an old revision of the document!

IBM DB2 to PostgreSQL Migration

SQLines open source tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from IBM DB2 to PostgreSQL:

SQLines Data - Data transfer, schema migration and validation tool
SQLines SQL Converter - SQL scripts conversion tool

Databases:

IBM DB2 for LUW and z/OS 10.x, 9.x, 8.x and 7.x
PostgreSQL 10.x and 9.x

Migration Reference

Data Types

Data Types

Data type mapping between DB2 and PostgreSQL:

	DB2		PostgreSQL
1	BIGINT	64-bit integer	BIGINT
2	BLOB(n)	Binary large object, 1 ⇐ n ⇐ 2G	BYTEA
3	CHAR(n), CHARACTER(n)	Fixed-length string, 1 ⇐ n ⇐ 254	CHAR(n), CHARACTER(n)
4	CHAR(n) FOR BIT DATA	Fixed-length byte string, 1 ⇐ n ⇐ 254	BYTEA
5	CHARACTER VARYING(n)	Variable-length string, 1 ⇐ n ⇐ 32672	VARCHAR(n)
6	CLOB(n)	Character large object, 1 ⇐ n ⇐ 2G	TEXT
7	DATE	Date (year, month and day)	DATE
8	DBCLOB(n)	UTF-16 character large object, 1 ⇐ n ⇐ 1G	TEXT
9	DECIMAL(p,s), DEC(p,s)	Fixed-point number	DECIMAL(p,s), DEC(p,s)
10	DECFLOAT(16 \| 34)	IEEE floating-point number	FLOAT
11	DOUBLE [PRECISION]	Double-precision floating-point number	DOUBLE PRECISION
12	FLOAT(p)	Double-precision floating-point number	DOUBLE PRECISION
13	GRAPHIC(n)	Fixed-length UTF-16 string, 1 ⇐ n ⇐ 127	CHAR(n)
14	INTEGER, INT	32-bit integer	INTEGER, INT
15	NCHAR(n)	Fixed-length UTF-16 string, 1 ⇐ n ⇐ 127	CHAR(n)
16	NCHAR VARYING(n)	Varying-length UTF-16 string, 1 ⇐ n ⇐ 16336	VARCHAR(n)
17	NCLOB(n)	UTF-16 character large object, 1 ⇐ n ⇐ 1G	TEXT
18	NUMERIC(p,s), NUM(p,s)	Fixed-point number	NUMERIC(p,s)
19	NVARCHAR(n)	Varying-length UTF-16 string, 1 ⇐ n ⇐ 16336	VARCHAR(n)
20	REAL	Single-precision floating-point number	REAL
21	SMALLINT	16-bit integer	SMALLINT
22	TIME	Time (hour, minute, and second)	TIME(0)
23	TIMESTAMP(p)	Date and time with fraction	TIMESTAMP(p)
24	VARCHAR(n)	Variable-length string, 1 ⇐ n ⇐ 32672	VARCHAR(n)
25	VARCHAR(n) FOR BIT DATA	Variable-length byte string, 1 ⇐ n ⇐ 32672	BYTEA
26	VARGRAPHIC(n)	Variable-length UTF-16 string, 1 ⇐ n ⇐ 16336	VARCHAR(n)
27	XML	XML data	XML

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to Oracle

Migration to SQL Server

Migration to MySQL

Migration to PostgreSQL

Migration to SingleStore

Migration to IBM DB2

Migration to Redshift

Migration to Snowflake

Migration to Apache Hive

Migration to Spark

Migration to Presto/Trino

Migration to Netezza

Migration to Greenplum

Migration to EsgynDB

Application Conversion

Database Reference

IBM DB2 to PostgreSQL Migration

Migration Reference

Data Types