"soni de" <soni.de@xxxxxxxxx> writes:
> But we want to set this timezone parameter to IST.
Which "IST" are you interested in? Irish, Israel, or Indian Standard Time?
Postgres prefers to use the zic timezone names, which are less
ambiguous. Try this to see likely options:
regression=# select * from pg_timezone_names where abbrev = 'IST';
name | abbrev | utc_offset | is_dst
---------------+--------+------------+--------
Asia/Calcutta | IST | 05:30:00 | f
Asia/Colombo | IST | 05:30:00 | f
Europe/Dublin | IST | 01:00:00 | t
Eire | IST | 01:00:00 | t
(4 rows)
If you're after Indian Standard Time, set timezone to 'Asia/Calcutta'.
You'll probably also want to set timezone_abbreviations to 'India' so
that "IST" is interpreted the way you want in timestamp datatype input.
See
http://www.postgresql.org/docs/8.2/static/datetime-config-files.html
regards, tom lane
