1、使用now()
postgres=# select now();
now
-------------------------------
2019-03-26 22:30:10.204689-04
(1 row)
postgres=#
2、current_timestamp
postgres=# select current_timestamp;
current_timestamp
------------------------------
2019-03-26 22:31:25.09278-04
(1 row)
postgres=#