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.
CS/IT Systems Engineer
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of tlm
Sent: Tuesday, December 19, 2006 8:35 AM
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?
In response to
pgsql-novice by date
|Next:||From: Andreas Kretschmer||Date: 2006-12-19 16:37:45|
|Subject: Re: print statements?|
|Previous:||From: tlm||Date: 2006-12-19 13:35:27|
|Subject: print statements?|