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

Re: print statements?

From: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
To: "tlm" <tlm1905(at)gmail(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: print statements?
Date: 2006-12-19 16:27:03
Message-ID: F8E84F0F56445B4CB39E019EF67DACBA40192C@exchsrvr.winemantech.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

 

--

Brandon Aiken

CS/IT Systems Engineer

________________________________

From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of tlm
Sent: Tuesday, December 19, 2006 8:35 AM
To: pgsql-novice(at)postgresql(dot)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

In response to

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2006-12-19 16:37:45
Subject: Re: print statements?
Previous:From: tlmDate: 2006-12-19 13:35:27
Subject: print statements?

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