Re: Migrating to DB2 from Postgres - Mailing list pgsql-general

To get the data you are may have more luck doing each table one at a time :

for each table <TABLE>
in Pg use

COPY  <TABLE> TO '<the file for TABLE>' USING DELIMITERS ',';

in DB2 use

db2 LOAD FROM '<the file for TABLE>' OF DEL INSERT INTO <TABLE>

good luck

Mark