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