Global variables in plpgsql

[Nick Raj]

Hi,
Can anyone know how to define global variable in plpgsql?
Thanks

Regards,
Raj

[Christopher Browne]

Post by Nick Raj
Can anyone know how to define global variable in plpgsql?

I expect you should consult the manual page on the command CREATE
TABLE. That's what would be the nearest SQL equivalent to a "global
variable."

http://www.postgresql.org/docs/9.0/static/sql-createtable.html

[Pavel Stehule]

Hello

Post by Nick Raj
Hi,
Can anyone know how to define global variable in plpgsql?
Thanks
Regards,
Raj

plpgsql doesn't support global or session variables.

There are a few techniques - you can emulate it


http://www.postgresql.org/docs/8.3/static/plperl-global.html

Regards

Pavel Stehule