Re: [GENERAL] Specific database vars, again...

On Apr 20, 2010, at 12:35 PM, Glus Xof wrote:

> 2010/4/20 Ben Chobot <bench(at)silentmedia(dot)com>:
>>
>> On Apr 20, 2010, at 10:53 AM, Glus Xof wrote:
>>
>>> Hi again,
>>>
>>> Maybe, I didn't explain my question enough.
>>>
>>> I need to record properties that belongs to an specific database (and
>>> so, they work at database level... not at global scope:
>>>
>>> * Or, must to create an specific one-row table ?.
>>
>> Depending on how you intend to use these variables, this sounds like a fine idea to me. What are your problems with it?
>
> The idea is storing values that can be remotely accessed by a
> C++/libpqxx application. So, I just see that the first alternative
> that I proposed (the use of \set variables) is really not good. But
> the rest remains...
>
> Now, the only option I have is to create a table, define one column
> per variable, for using just one row. This can be accessed by a select
> sql command...
>
> You know other alternatives ???

I could probably think of some, but why? Storing values in tables is a perfectly sensible way to allow clients to access per-database data.