DST and time zones - Mailing list pgsql-novice

Hello,

I need a method of returning a date in a given timezone and accomidating
DST.  For example, my server is set to UTC, Id like to return the epoch
for Vancouver Canada.  You can do a

select extract(epoch from now() at time zone 'pst');

Of course this is wrong since DST is in affect, so it should be 'pdt'
not 'pst'.  I understand that postgresql doesn't do this itself, it uses
the OS, however does anyone know a crafty way to get the current time in
any timezone, whether DST is in effect or not?

Im using pg 7.4.3 running on Linux 2.4.25.

Thanks in advance.
A Gilmore