LLE10224 : Howto show information from variables like printf in a pgsql function on postgres

Symptom:

You use postgresql and want to know the values of your variables in a pl/pgsql function

Cause:

none

Solution:

You use the raise command to do this. With raise you can see the output as information.

e.g.

raise notice 'Primary key is %', primkey;
raise notice 'Your own created internal key is %', lubbykey;

For more information have a look in the outstanding postgres manual.

Disclaimer:

The information provided in this document is intended for your information only. Lubby makes no claims to the validity of this information. Use of this information is at own risk!