Postgres Pro
Downloads
Home   >   mailing lists

Re: Export tab delimited from mysql to postgres. - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Export tab delimited from mysql to postgres.
Date
Msg-id 20041011234050.GA17772@wolff.to
Whole thread Raw
In response to Re: Export tab delimited from mysql to postgres.  (Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>)
List pgsql-sql
Tree view 
On Tue, Oct 12, 2004 at 09:23:41 +1000, Theo Galanakis <Theo.Galanakis@lonelyplanet.com.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?

pgsql-sql by date:

Previous
From: Theo Galanakis
Date:
Subject: Re: Export tab delimited from mysql to postgres.
Next
From: Christopher Browne
Date:
Subject: Re: Export tab delimited from mysql to postgres.