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

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

pgsql-admin by date

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

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