Windows DatabaseebooksStatistical Information

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!
Copyright © 2004-2011 Lubby (V3.0.10 Aug 2011)
Sponsored by Keskon.
Statistical information by Google Analytics