Hi,
I've got a rather complicated csv file whose records I'd like to
insert into a table. I've got most of the records whipped into shape,
but there are a handful that are still getting skipped.
How do I trap them using psql?
That is, I use perl to parse the file and create an insert.sql file. I
use psql with \i to read the file. I'd like to somehow capture the
messages for the records that don't get successfully inserted.
thanks,
Tom
kellert(at)ohsu(dot)edu
503-494-2442