Re: Is there a PostgreSQL utility that is similiar to Oracles

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

In response to

Browse pgsql-general by date

  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