Re: trapping errors

On Wed, Oct 1, 2008 at 3:41 PM, Thomas Keller <kellert(at)ohsu(dot)edu> wrote:

> 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.
>

You could run this from a terminal session:

$ psql -f insert.sql 2>&1 >log.txt

$ psql -f insert.sql 2>&1 | tee -f log.txt

if you want to see the errors as they happen...

-selena

--
Selena Deckelmann
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily