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

Reply via email to