Re: [GENERAL] printing variable values in pl/pgsql functions

2007-05-08 Thread Martin Gainty
\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

Re: [GENERAL] printing variable values in pl/pgsql functions

2007-05-08 Thread Jasbinder Singh Bali
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 and wrote: Hi, I have a pl/pgsql in which i have to print various variable value