Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Masaru SugawaraDate: 2001-09-28 23:17:50
Subject: Re: Function Help
Previous:From: Mihai GheorghiuDate: 2001-09-28 21:22:14
Subject: Triggers again

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group