2016-01-20 16:38 GMT+01:00 Steve Crawford <scrawf...@pinpointresearch.com>:
> 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 > > This is list of know timezones. So if you are searching "abbrev" then you can find it there. Pavel > -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 >> > >
