Re: Custom Class variables

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Custom Class variables
Date: 2009-07-14 23:44:27
Message-ID: 20090714234427.GS4799@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Michaels 2009-07-14 23:47:16 problem with pg_restore?
Previous Message Mike Toews 2009-07-14 23:41:23 PL/Python debugging - line numbers