Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group