查看数据库的时区与时间:
postgres=# select now(); now ------------------------------ 2017-09-29 12:54:04.04916+08 (1 行记录)
查看时区:
postgres=# show time zone; TimeZone --------------- Asia/Shanghai (1 行记录)
查看数据库可供选择的时区:
postgres=# select * from pg_timezone_names; name | abbrev | utc_offset | is_dst ----------------------------------------+--------+------------+-------- Africa/Abidjan | GMT | 00:00:00 | f Africa/Accra | GMT | 00:00:00 | f Africa/Addis_Ababa | EAT | 03:00:00 | f Africa/Algiers | CET | 01:00:00 | f Africa/Asmara | EAT | 03:00:00 | f Africa/Asmera | EAT | 03:00:00 | f Africa/Bamako | GMT | 00:00:00 | f Africa/Bangui | WAT | 01:00:00 | f Africa/Banjul | GMT | 00:00:00 | f Africa/Bissau | GMT | 00:00:00 | f .......................
设置时区:
postgres=# set time zone "Asia/Shanghai"; SET
原文：http://www.cnblogs.com/liangping/p/7610588.html