[SQL] Capturing pgsql ERRORS/NOTICES to file

2003-09-26 Thread George Weaver
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.   Tha

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 informati

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

2003-09-26 Thread George Weaver
D]>; <[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 that will update some > > functions in a database for a remote user similar to: > > &

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

2003-09-26 Thread Wei Weng
screen. > > Is this possible? > > 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

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: