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" or similar (with three text rows: key, value, type) so I can avoid having 20 separate one row, one column tables for various settings. Defining a trigger to coerce the value to the desired type is trivial, so your application can depend on not having completely bogus values in these settings. A more esoteric possibility would be to define functions that return a constant value. > & saveables when the database tables are dumped. Not exactly sure what you mean here. If you use pg_dump, usually the whole db is dumped (table definition, data, sequences, functions, ...) cheers -- vbi -- Wenn ein englisches Flugzeug mit deutschen Passagieren über der Grenze zwischen Frankreich und Spanien abstürzt ... wo werden dann die Überlebenden begraben?
Attachment:
signature.asc
Description: This is a digitally signed message part.
