Default timezones and Postgres - Mailing list pgsql-general

From Dr. Evil
Subject Default timezones and Postgres
Date
Msg-id 20020219012116.24260.qmail@sidereal.kz
Whole thread Raw
Responses Re: Default timezones and Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I am wondering how to force Postgres to simply store all time
information in the database in the UTC timezone.  Is there a way to do
this that doesn't involve changing the timezone config of this entire
computer?  What will happen is that we have users all over the world
in many different time zones.  Each user will be able to set his own
prefs so that data will be displayed in his timezone.  In this case,
the only timezone that makes any sense for internal usage is UTC,
right?  Right now it seems to be storing everything in my local
timezone which isn't good.

Thanks for any sugestions.

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Cannot restart the postmaster
Next
From: Samik Raychauhduri
Date:
Subject: Re: SQL: Are the "" around table & coloumnames necessary?