Re: [GENERAL] update time zone in timestamps

2003-12-05 Thread CSN
SHOW ALL shows TimeZone is 'unknown'. postgres.conf says 'TZ' is used for default. Where should TZ be set (it doesn't appear to be set on my RH9 system)? Thanks, CSN --- CSN <[EMAIL PROTECTED]> wrote: > > Does Postgres use the system's timezone > (/etc/localzone) at all? Or does "SET TIME ZONE

Re: [GENERAL] update time zone in timestamps

2003-12-05 Thread CSN
Does Postgres use the system's timezone (/etc/localzone) at all? Or does "SET TIME ZONE 'MST'" need to be placed in postgres.conf to make it always used (I set it via psql, but it appears to only be set for that connection)? Thanks, CSN --- Tom Lane <[EMAIL PROTECTED]> wrote: > CSN <[EMAIL PROT