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

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

pgsql-sql by date

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

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