Subject: Sending errors from psql to error file
From: Devin Whalen <devin@synapticvision.com>
Reply-To: devin@synapticvision.com
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Organization: Synaptic Vision
Message-Id: <1092320416.23985.24.camel@192.168.1.80>
Mime-Version: 1.0
Date: Thu, 12 Aug 2004 10:20:17 -0400

Hello,

I am trying to migrate a client from one database to another.  Basically
we designed a web application for them using Postgresql but we have made
many changes to the design of our application since version 1.  Now they
want to upgrade.  So basically I have to pg_dump their current data and
then import it into our new schema.  Now, of course I realize that there
are going to be errors.  But they have a lot and I mean a lot of data. 
I don't want to have to sit there and watch the import go by, I want to
run a command and then look in a file for any errors after the import is
complete.  I tried this command but it didn't work:
gunzip -c cli_postDataInserts.sql.gz | psql cli_post -U system | grep
"ERROR:*" > import_errors

Any help is appreciated.

Thanks.

-- 
Devin Whalen
Programmer
Synaptic Vision Inc
Phone-(416) 539-0801
Fax- (416) 539-8280
1179A King St. West
Toronto, Ontario
Suite 309 M6K 3C5
Home-(416) 653-3982