Thread: printing variable values in pl/pgsql functions

printing variable values in pl/pgsql functions

From
"Harpreet Dhaliwal"
Date:
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

printing variable values in pl/pgsql functions

From
"Harpreet Dhaliwal"
Date:


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

Re: printing variable values in pl/pgsql functions

From
"Jasbinder Singh Bali"
Date:
you can use
RAISE NOTICE 'i want to print % and %', var1,var2;

then run your function and click the MESSAGE tab at the bottom of your query analyzer screen and you'll see sometime like

NOTICE: i want to print <value of var 1> and <value of var2

you can use any number of RAISE NOTICE statements as you want and they will be printed in order under messages.

I hope this helps
~Jas

On 5/8/07, Harpreet Dhaliwal <harpreet.dhaliwal01@gmail.com> wrote:


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

Re: printing variable values in pl/pgsql functions

From
"Martin Gainty"
Date:
\echo will print contents of whatever follows
 
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 -----
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