Re: print statements?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Frank Bax <fbax(at)sympatico(dot)ca>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: print statements?
Date: 2006-12-21 06:18:18
Message-ID: 14355.1166681898@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Frank Bax <fbax(at)sympatico(dot)ca> writes:
> At 08:35 AM 12/19/06, tlm wrote:
>> 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?

> select 'half way already?';

Also, there's a \echo command in psql that might help.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message uldis 2006-12-21 11:06:51 update order
Previous Message Bruno Wolff III 2006-12-21 05:45:56 Re: Getting a count from an update