Re: COPY command with bad input

On Tue, May 15, 2007 at 02:11:00AM -0700, Sandeep Khandelwal wrote:
> I am trying to load data from a text file to Postgres table using
> COPY command. If text file has some invalid rows then COPY command
> stops at the first error.
> 
> As you can see, MySQL “load data infile” has IGNORE option.  If you
> specify IGNORE, input rows that duplicate an existing row on a
> unique key value are skipped. Do we have similar option for Postgres
> COPY command ?

Not yet; it's on the developers' TODO list:

http://www.postgresql.org/docs/faqs.TODO.html

  * Allow COPY to report error lines and continue

In the meantime you could check out pgloader:

http://pgfoundry.org/projects/pgloader/

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq