Skip site navigation (1) Skip section navigation (2)

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

From: Glus Xof <gtglus(at)gmail(dot)com>
To: Ben Chobot <bench(at)silentmedia(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [GENERAL] Specific database vars, again...
Date: 2010-04-20 20:08:03
Message-ID: s2p18c2d6a11004201308s15e00956zd5f1681438663eb4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
2010/4/20 Ben Chobot <bench(at)silentmedia(dot)com>:
> 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.

Thanks !

Glus

In response to

pgsql-novice by date

Next:From: Thomas KellererDate: 2010-04-20 20:23:34
Subject: Re: [GENERAL] Specific database vars, again...
Previous:From: Ben ChobotDate: 2010-04-20 19:38:15
Subject: Re: [GENERAL] Specific database vars, again...

pgsql-general by date

Next:From: Thomas KellererDate: 2010-04-20 20:23:34
Subject: Re: [GENERAL] Specific database vars, again...
Previous:From: Ben ChobotDate: 2010-04-20 19:38:15
Subject: Re: [GENERAL] Specific database vars, again...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group