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

Le vendredi 17 novembre 2006 22:07, Wm.A.Stafford a écrit :
> 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.

pgloader is the tool you're looking for, it will give you reject log file and
reject data file, and has many useful options, as for example:
-p, --pedantic pedantic mode, stop processing on warning
-n, --dry-run simulate operations, don't connect to the db
-T, --truncate truncate tables before importing data
number of input lines to process
-F FROMCOUNT, --from=FROMCOUNT
number of input lines to skip
-I FROMID, --from-id=FROMID
wait for given id on input to begin

Pedantic mode makes pgloader behave as COPY command, damn usefull in debug
mode or if you have the opportunity to correct data.

As I just gave you information to download code and debian package, I won't
insist that much on it :)
--
Dimitri Fontaine
http://www.dalibo.com/