Re: Is there a PostgreSQL utility that is similiar to Oracles - Mailing list pgsql-general

From Tony Caduto
Subject Re: Is there a PostgreSQL utility that is similiar to Oracles
Date
Msg-id 4561DAC1.6040707@amsoftwaredesign.com
Whole thread Raw
In response to Is there a PostgreSQL utility that is similiar to Oracles sql loader?  ("Wm.A.Stafford" <stafford@marine.rutgers.edu>)
List 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


pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: Eliminating bad characters from a database for upgrading from 7.4 to 8.1
Next
From: "Wm.A.Stafford"
Date:
Subject: PostgreSQL equivalent of the Oracale 'unique' qualifier