Re: printing variable values in pl/pgsql functions

From: "Martin Gainty" <mgainty(at)hotmail(dot)com>
To: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: printing variable values in pl/pgsql functions
Date: 2007-05-09 01:18:01
Message-ID: BAY133-DAV16D4A25BB930259DD31FA6AE3B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

\echo will print contents of whatever follows
http://www.postgresql.org/docs/8.1/static/app-psql.html

M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.

----- Original Message -----
From: Harpreet Dhaliwal
To: pgsql-general(at)postgresql(dot)org
Sent: Tuesday, May 08, 2007 8:40 PM
Subject: [GENERAL] printing variable values in pl/pgsql functions

Hi,

I have a pl/pgsql in which i have to print various variable values during the execution of the function to see
what values are getting populated inside those variables with due course of time.

PRINT <variable name>
doesn't work.

Can anyone tell me how to print these values??

Thanks,
~Harpreet

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2007-05-09 04:32:32 Views- Advantages and Disadvantages
Previous Message Jasbinder Singh Bali 2007-05-09 01:12:23 Re: printing variable values in pl/pgsql functions