Thread: pg_bulkload

pg_bulkload

From
John Randall
Date:
Does anyone know if this utility can generate a log file of records that for some reason do not load to a PostgreSQL database? I’m looking for something like Oracle’s SQLLDR where an error is generated when a record fails to load. If not pg_bulkload, perhaps there is some other like utility. Thanks in advance

Re: pg_bulkload

From
Adrian Klaver
Date:
On Wednesday 07 January 2009 4:10:34 pm John Randall wrote:
> Does anyone know if this utility can generate a log file of records that
> for some reason do not load to a PostgreSQL database? I’m looking for
> something like Oracle’s SQLLDR where an error is generated when a record
> fails to load. If not pg_bulkload, perhaps there is some other like
> utility. Thanks in advance

I don't know about pg_bulkload, but pgloader does:
http://pgfoundry.org/projects/pgloader/

--
Adrian Klaver
aklaver@comcast.net