The easiest method would be to write the script using PHP, Perl, or similar. That would allow everything to be in one transaction while still allowing you to do output and things like exception handling.
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of tlm
Sent: Tuesday, December 19, 2006 8:35 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] print statements?
[ 2nd try ]
Hi. I have an automated script that essentially feeds a long sequence of SQL statements to psql, as a single transaction. For debugging purposes, I would like to insert the equivalent of print statements (to write messages to stdout, stderr, or maybe some pre-specified log file) at various points in this sequence. How is this done?
Thanks!
tlm