Re: Custom Class variables - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Custom Class variables
Date
Msg-id 20090714234427.GS4799@alvh.no-ip.org
Whole thread Raw
In response to Custom Class variables  (Michael Gould <mgould@intermodalsoftwaresolutions.net>)
List pgsql-general
Michael Gould wrote:
> I have created the following in my postgres.conf file
>
> custom_variable_classes = 'iss'
>
> In a SQL session I've tried
>
> Set iss.one = '1'
> set iss.two = '2'
>
> Select * from iss;
>
> How do I access the values from the custom class in sql code?

show iss.one;
select current_setting('iss.one');

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Mike Toews
Date:
Subject: PL/Python debugging - line numbers
Next
From: Jim Michaels
Date:
Subject: problem with pg_restore?