Thread: 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
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
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
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
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
\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.
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 DhaliwalSent: Tuesday, May 08, 2007 8:40 PMSubject: [GENERAL] printing variable values in pl/pgsql functionsHi,
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