This is an old revision of the document!
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
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 |