Re: [ADMIN] COPY command and skipping errors

2005-09-22 Thread Alvaro Herrera
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 m

Re: [ADMIN] COPY command and skipping errors

2005-09-22 Thread Bruce Momjian
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 cont

[ADMIN] COPY command and skipping errors

2005-09-22 Thread Tomeh, Husam
Title: Message   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 lo