Re: Export tab delimited from mysql to postgres.

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Theo Galanakis <Theo(dot)Galanakis(at)lonelyplanet(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Export tab delimited from mysql to postgres.
Date: 2004-10-11 23:40:50
Message-ID: 20041011234050.GA17772@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Oct 12, 2004 at 09:23:41 +1000,
Theo Galanakis <Theo(dot)Galanakis(at)lonelyplanet(dot)com(dot)au> wrote:
>
> Could you provide a example of how to do this?
>
> I actually ended up exporting the data as Insert statements, which
> strips out cf/lf within varchars. However it takes an eternity to import
> 200,000 records... 24 hours infact???? Is this normal?

Are you doing the load in one transaction?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Browne 2004-10-12 00:46:02 Re: Export tab delimited from mysql to postgres.
Previous Message Theo Galanakis 2004-10-11 23:23:41 Re: Export tab delimited from mysql to postgres.