Re: Migrating to DB2 from Postgres

From: Mark kirkwood <markir(at)slingshot(dot)co(dot)nz>
To: shaunnx(at)my-deja(dot)com (X)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Migrating to DB2 from Postgres
Date: 2001-09-28 22:33:58
Message-ID: 01092910335800.01532@spikey.slithery.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Masaru Sugawara 2001-09-28 23:17:50 Re: Function Help
Previous Message Mihai Gheorghiu 2001-09-28 21:22:14 Triggers again