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

2010-04-22 Thread Glus Xof
Thanks to all that replied my question ! I'll implement the Thomas Kellerer's. Glus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

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

2010-04-21 Thread Adrian von Bidder
On Tuesday 20 April 2010 19.53:34 Glus Xof wrote: > Could I use the \set statements \set is a feature of the "psql" commandline frontend. These values are never even seen by the database and are not preserved anywhere. Also, if you develop applications, you'll usually not use the psql frontend

Re: [GENERAL] Specific Database Vars

2010-04-21 Thread Adrian von Bidder
Hi, On Tuesday 20 April 2010 15.50:35 Glus Xof wrote: > I know that can use one-row tables but, > > I'd like to know if it's possible to define variables attached to one > specific database, Yes, one row tables :-) What I usually do for those random values is a table like "GlobalParameters"

[GENERAL] Specific database vars, again...

2010-04-20 Thread Glus Xof
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: * Could I use the \set statements ? but... the vars defined are not in a database scope but a global, aren't they ?.

[GENERAL] Specific Database Vars

2010-04-20 Thread Glus Xof
Hi guys, I'm a newbie using PostgreSQL. I know that can use one-row tables but, I'd like to know if it's possible to define variables attached to one specific database, & saveables when the database tables are dumped. Glus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)