| From: | Edward Chase <echase(at)homer(dot)providence(dot)edu> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: COPY |
| Date: | 2000-03-31 18:05:07 |
| Message-ID: | 3.0.6.32.20000331130507.0083c710@homer.providence.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)providence(dot)edu
Providence College | http://www.providence.edu
Computer Services | http://studentweb.providence.edu
Providence, RI 02918 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KOOPMAN,JON (A-SantaClara,ex1) | 2000-03-31 22:41:58 | LargeObject storage doesn't go away |
| Previous Message | Wierzbicki, Ralf | 2000-03-31 15:28:35 | COPY |