Felix's Second Life 電腦數碼世界

/etc/postgresql/10/main/postgresql.conf

把timezone改成你要

sudo service postgresql restart 

column default set to now

create temporary table test(
    id int, 
    ts timestamp without time zone default (now() at time zone 'utc')
);

參考:

https://kb.objectrocket.com/postgresql/postgresql-set-time-zone-1064