Description
There are two problems.
- \set command does not work.
- Client timezone does not work when any timezone is configured for input table.
You can reproduce as follows:
default> create table test (col time); OK default> insert into test select current_time(); OK default> select * from test; col ------------------------------- 05:32:54.161999 (1 rows, 0.018 sec, 0 B selected) default> set time zone 'GMT+9' default> select * from test; col ------------------------------- 05:32:54.161999 (1 rows, 0.019 sec, 0 B selected) default> create table test2 (col time) with ('timezone'='ASIA/Seoul'); OK default> insert into test2 select current_time(); OK default> select * from test2; col ------------------------------- 14:22:52.747999 (1 rows, 0.02 sec, 0 B selected) default> \set timezone GMT-3 default> select * from test2; col ------------------------------- 14:22:52.747999 (1 rows, 0.018 sec, 0 B selected) default> set time zone 'GMT-3'; OK default> select * from test2; col ------------------------------- 02:22:52.747999 (1 rows, 0.021 sec, 0 B selected) default> \set timezone GMT+9 default> select * from test2; col ------------------------------- 02:22:52.747999 (1 rows, 0.018 sec, 0 B selected)