Re: Asia/kolkatta timezone - Mailing list pgadmin-support

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