From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | stafford(at)marine(dot)rutgers(dot)edu, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is there a PostgreSQL utility that is similiar to Oracles |
Date: | 2006-11-20 16:41:37 |
Message-ID: | 4561DAC1.6040707@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Wm.A.Stafford wrote:
> We are trying to load our PostgreSQL DB with data that contains many
> corrupted rows. I recall that sql loader will skip corrupted rows and
> keep going. We are using the PostgreSQL copy command to load and it
> just gives up when the first corrupted row is encountered.
>
> Thanks in a advance,
> -=bill
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
You could give Lightning Admin a try, we have full import capabilities
(though not as fast as using COPY from a CSV file)
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
Only $9.99 until December 1st 2006
From | Date | Subject | |
---|---|---|---|
Next Message | Gurjeet Singh | 2006-11-20 16:50:47 | Re: [GENERAL] Allowing SYSDATE to Work |
Previous Message | Gurjeet Singh | 2006-11-20 16:41:01 | Re: Eliminating bad characters from a database for upgrading from 7.4 to 8.1 |