Assuming you are on Linux/Unix:
psql YOURDBNAME -e < sqlscript.txt > output.txt 2>&1
The -e option echos the script too which is helpful when debugging.
On NT do this:
(see Q110930 for more info)
psql YOURDBNAME -e < sqlscript.txt 1> output.txt 2>&1
--rob
----------
From: Huy Do [SMTP:huy@travel.com.au]
Sent: Wednesday, December 20, 2000 12:37 AM
To: pgsql-novice@postgresql.org
Subject: Capturing all output from psql into a file
Hi,
I am doing this mass table creation (approx 600 tables) and then
mass dump of records into these tables (~900megs of flat files).
All the table creation and record copy is being done from a file
using \i sqlscript.txt.
How can I capture all the output which comes out from psql. I need
all the errors and not just the query result.
I have tried to use \o file.txt and \g file.txt but they only
seem to output the query result.
Many thanks.
Huy