Re: {Spam} Copy cmd error - Mailing list pgsql-admin

From Dimitri Fontaine
Subject Re: {Spam} Copy cmd error
Date
Msg-id 200708271754.02347.dfontaine@hi-media.com
Whole thread Raw
In response to Copy cmd error  (<qinghuamail-postgresqlfans@yahoo.com>)
List pgsql-admin
Hi,

Le lundi 27 août 2007, qinghuamail-postgresqlfans@yahoo.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

Attachment

pgsql-admin by date:

Previous
From: feng xinguo
Date:
Subject: use copy command!
Next
From: "Medi Montaseri"
Date:
Subject: Re: PostgreSQL and virtualization