Skip site navigation (1) Skip section navigation (2)


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: (view raw, whole thread or download thread mbox)
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:
>	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      |
 Computer Services       |
 Providence, RI  02918   |

pgsql-admin by date

Next:From: KOOPMAN,JON (A-SantaClara,ex1)Date: 2000-03-31 22:41:58
Subject: LargeObject storage doesn't go away
Previous:From: Wierzbicki, RalfDate: 2000-03-31 15:28:35
Subject: COPY

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group