Turning Off PotgrSQL Output Messages

From: "Behzad Mahini" <behzad(at)monosphere(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Turning Off PotgrSQL Output Messages
Date: 2005-08-12 00:27:49
Message-ID: 5122464168183D4FAB69535A590159C96EDE69@us-red-corp1.monosphere.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have tried different options to turnoff the output mode of psql
(turning off the STDERR & STDOUT and redirecting it to another file),
and I have not been successful. The steps I have taken to capture the
output of my script in an output file using the '\o' option, are as
follows:

# \o error_log \i script.sql

To provide more background, I have a wrapper "sql" code that launches a
few other "sql" scripts, and I start it as follows at the PSQL level:

# \o wrapper_log_out \i wrapper.sql

Within the wrapper.sql script, I have the following lines (which
unsuccessfully attempt to turnoff PostgreSQLcapture scripts:

\o createTable_log_out \i createTableScript

\o insertTable_log_out \i insertTableScript

...as it is obvious, I have placed all of my Table creations within the
"createTableScript", and all of my insert statements in the
"insertTableScript". Incidentally, initially within the 'wrapper.sql'
script all I had were the following lines, and that option did not work
either:

\i createTableScript

\i insertTableScript

Any suggestions as to how to go about this issue?

Thanks,

Behzad

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2005-08-12 00:36:49 Re: plphp: PHP Warning: Call-time pass-by-reference has been deprecated
Previous Message Tom Lane 2005-08-12 00:21:16 Re: No PUBLIC access by default?