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