[SQL] Capturing pgsql ERRORS/NOTICES to file

2003-09-26 Thread George Weaver
I amin the process of creating a batch file that will update some functions in a database for a remote user similar to: psql -o output dbname functionupdate.sql Is there any way to save any ERROR and NOTICEmessages to a file? The -o option doesn't capture this information. Thanks,

Re: [SQL] Capturing pgsql ERRORS/NOTICES to file

2003-09-26 Thread Josh Berkus
George, I am in the process of creating a batch file that will update some functions in a database for a remote user similar to: psql -o output dbname functionupdate.sql Is there any way to save any ERROR and NOTICE messages to a file? The -o option doesn't capture this information. You

Re: [SQL] Capturing pgsql ERRORS/NOTICES to file

2003-09-26 Thread George Weaver
, September 26, 2003 1:33 PM Subject: Re: [SQL] Capturing pgsql ERRORS/NOTICES to file George, I am in the process of creating a batch file that will update some functions in a database for a remote user similar to: psql -o output dbname functionupdate.sql Is there any way to save any ERROR

Re: [SQL] Capturing pgsql ERRORS/NOTICES to file

2003-09-26 Thread Wei Weng
? George - Original Message - From: Josh Berkus [EMAIL PROTECTED] To: George Weaver [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:33 PM Subject: Re: [SQL] Capturing pgsql ERRORS/NOTICES to file George, I am in the process of creating a batch file

Re: [SQL] Capturing pgsql ERRORS/NOTICES to file

2003-09-26 Thread George Weaver
Hi Wei, I hadn't tried that, and it did the trick! Thank you! George - Original Message - From: Wei Weng [EMAIL PROTECTED] To: George Weaver [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 26, 2003 2:16 PM Subject: Re: [SQL] Capturing pgsql ERRORS/NOTICES to file