Re: COPY

Not knowing exactly what your doing and what psql is considering "bad",
have you thought about pre-processing your files first and eliminating
these bad records before importing them into your database?


At 10:28 AM 3/31/2000 -0500, Ralf wrote:
>
>Hello,
>
>    I think I asked this question before but will try again.
>I deal a lot with importing text files into my psql database and
>quite often there are bad records in those files.  'COPY' will
>abort the process whenever it encounters bad data.  Is there any
>way to make 'COPY' skip bad records and continue with the import
>process rather than abort the entire thing?
>
>Thanks in advance.

---------------------------------------------------------------
 Edward F. Chase III     |   echase@providence.edu
 Providence College      |   http://www.providence.edu
 Computer Services       |   http://studentweb.providence.edu
 Providence, RI  02918   |