On Thu, Sep 22, 2005 at 04:41:57PM -0400, Bruce Momjian wrote: > Tomeh, Husam wrote: > > > > Is there a way to skip errors during the run of the COPY command > > (loading data from a file to a table) like what Oracle SQL*Loader has? > > The reason I'm asking is that if the extract file from the mainframe has > > an invalid character, the COPY terminates and doesn't continue loading > > the rest of records. > > No, but it is on the TODO list:
Also, I think PGLoader can do this. It's on pgfoundry.org. -- Alvaro Herrera Architect, http://www.EnterpriseDB.com "Tiene valor aquel que admite que es un cobarde" (Fernandel) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
