On Apr 15, 2011, at 3:14 AM, Prasath Rajan wrote: > Hi, > I am running postgres in ubuntu, > > When I run below query, > > SELECT * FROM PG_TIMEZONE_NAMES > > IST "Asia/Kolkata" is not there. > > How to get my timezone.
This isn't really a pgadmin question, but the answer is that the timezone database uses the pre-2001 spelling: Asia/Calcutta | IST | 05:30:00 | f Cheers, M -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support