Re: {Spam} Copy cmd error

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: pgsql-admin(at)postgresql(dot)org, qinghuamail-postgresqlfans(at)yahoo(dot)com
Subject: Re: {Spam} Copy cmd error
Date: 2007-08-27 15:53:59
Message-ID: 200708271754.02347.dfontaine@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Le lundi 27 août 2007, qinghuamail-postgresqlfans(at)yahoo(dot)com a écrit :
> I use COPY cmd to import large data to database,but I have a question,
>
> when occured the first error, It always stopped, I need it to be
> continue,and reject the error rows to a file, how to do this?

You can try out pgloader, which has been made for this kind of requirements.
http://pgloader.projects.postgresql.org/

Please consider downloading the later version available, which is 2.2.1 as of
now.

Regards,
--
dim

In response to

  • Copy cmd error at 2007-08-27 08:18:35 from qinghuamail-postgresqlfans

Browse pgsql-admin by date

  From Date Subject
Next Message Medi Montaseri 2007-08-27 17:04:00 Re: PostgreSQL and virtualization
Previous Message Alvaro Herrera 2007-08-27 14:21:23 Re: vacuum killed because of out of memory