Thread: COPY command with bad input
Hi All. I am trying to load data from a text file to Postgres table using COPY command. If text file has some invalid rows then COPYcommand 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 existingrow on a unique key value are skipped. Do we have similar option for Postgres COPY command ? Please help me. Thanks, Sandeep ____________________________________________________________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091
Hi All. Please help me. Thanks, Sandeep ----- Original Message ---- From: Sandeep Khandelwal <sandeep_khandelwal27@yahoo.com> To: pgsql-interfaces@postgresql.org Sent: Tuesday, May 15, 2007 2:41:00 PM Subject: COPY command with bad input Hi All. I am trying to load data from a text file to Postgres table using COPY command. If text file has some invalid rows then COPYcommand 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 existingrow on a unique key value are skipped. Do we have similar option for Postgres COPY command ? Please help me. Thanks, Sandeep ____________________________________________________________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091 ____________________________________________________________________________________Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz
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