Is this of any use?
select * from pg_timezone_names where name = 'Europe/Lisbon';
name | abbrev | utc_offset | is_dst
---------------+--------+------------+--------
Europe/Lisbon | WET | 00:00:00 | f
-Steve
On Wed, Jan 20, 2016 at 7:24 AM, Steve Rogerson <steve...@yewtc.demon.co.uk>
wrote:
> On 20/01/16 13:27, Pavel Stehule wrote:
> >
> >
> >
> > Postgres doesn't store original TZ. It does recalculation to local TZ.
> If you
> > need original TZ, you have to store it separetely.
> >
>
> I know and that's what I'm trying to deal with. Given I know the origin
> TZ -
> as in Europe/Lisbon I'm trying to determine the short name so I can store
> it.
>
> I guess I'll have to use something other than pg to do it.
>
> Steve
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
