Re: Testing / debuging data import - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Testing / debuging data import
Date
Msg-id 20061004135351.GA22119@winnie.fuhr.org
Whole thread Raw
In response to Testing / debuging data import  (Brendon Gleeson <brendon@gleesonprop.co.za>)
Responses Re: Testing / debuging data import  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-novice
On Wed, Oct 04, 2006 at 09:03:50AM +0200, Brendon Gleeson wrote:
> Basically what I want to do is simulate a data import (from a file with
> full insert statements and no table creation), I want the offending
> record/line to be printed to stdout with a verbose / helpful error.

This doesn't quite meet your requirements, but have you looked at
pgloader?

http://pgfoundry.org/projects/pgloader/

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Brendon Gleeson
Date:
Subject: Testing / debuging data import
Next
From: Ray Stell
Date:
Subject: pg_ctl -D?