Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: COPY command with bad input
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Sandeep Khandelwal <sandeep_khandelwal27(at)yahoo(dot)com>
- Cc: pgsql-interfaces(at)postgresql(dot)org
- Subject: Re: COPY command with bad input
- Date: Thu, 17 May 2007 06:10:42 -0600
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
- References:
- COPY command with bad input
- From: Sandeep Khandelwal
- COPY command with bad input
- Prev by Date: Re: COPY command with bad input
- Next by Date: libpq: NULL in binary parameters
- Previous by thread: COPY command with bad input
- Next by thread: Re: COPY command with bad input
- Indexes: