Doubt on pg_timezone_names and pg_timezone_abbrevs

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Doubt on pg_timezone_names and pg_timezone_abbrevs
Date: 2025-04-01 03:38:50
Message-ID: CAFS1N4go0PyXzR=krVN1EqdBx+T_Wv+P736KxDyZ8ZGuCfi8Rw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello PG members,
I used 'IST' in a query like this - * (timestamp_hour) at time zone 'IST'
time_ist *and did not get the expected output - timestamp in Indian
Standard Time. So I queried the 2 views that provide timezone info and did
not really understand the abbrev column.
select name, abbrev, utc_offset from pg_timezone_names where abbrev =
'IST' ;
name | abbrev | utc_offset
---------------+--------+------------
Eire | IST | 01:00:00
Asia/Kolkata | IST | 05:30:00
Asia/Calcutta | IST | 05:30:00
Europe/Dublin | IST | 01:00:00

select * from pg_timezone_abbrevs where abbrev = 'IST' ;
abbrev | utc_offset | is_dst
--------+------------+--------
IST | 02:00:00 | f

This is PostgreSQL 13.15 on AWS RDS. We have the same abbrev for 4
timezones in pg_timezone_names.
Regards,
Jayadevan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2025-04-01 03:58:11 Re: Doubt on pg_timezone_names and pg_timezone_abbrevs
Previous Message David Rowley 2025-03-31 20:28:00 Re: Querying one partition in a function takes locks on all partitions