예제를 보시고 직접 수행해보세요. (PostgreSQL 9.3 부터 지원기능)
enterprisedb@[local]:5445:edb]
SQL> select current_timestamp; \watch 1 -- 1초마다 auto refresh
current_timestamp
----------------------------------
20-MAR-15 10:03:44.243509 +09:00
(1 row)
Watch every 1s Fri Mar 20 10:03:44 2015
current_timestamp
----------------------------------
20-MAR-15 10:03:44.247115 +09:00
(1 row)
Watch every 1s Fri Mar 20 10:03:45 2015
current_timestamp
----------------------------------
20-MAR-15 10:03:45.248368 +09:00
(1 row)
Watch every 1s Fri Mar 20 10:03:46 2015
current_timestamp
----------------------------------
20-MAR-15 10:03:46.249594 +09:00
(1 row)
Watch every 1s Fri Mar 20 10:03:47 2015
current_timestamp
----------------------------------
20-MAR-15 10:03:47.250834 +09:00
(1 row)