David Fetter <david@xxxxxxxxxx> writes: > On Fri, Mar 02, 2007 at 01:53:28PM -0600, Adam Rich wrote: >> Is there any way to define custom variables per session scope? > You can have them in PL/Perl(U), PL/Tcl(U) and PL/PythonU and other > such PLs, and you can create SQL accessors for them. Another possibility is the "customized GUC options" route: you can take advantage of the fact that the backend will let you set variables that don't exist yet, if they are in a namespace that postgresql.conf says is OK. http://www.postgresql.org/docs/8.2/static/runtime-config-custom.html This approach probably doesn't scale nicely to a whole lotta values, but for a dozen or so strings it'd work well enough. regards, tom lane
