Date/Time Functions and Operators (Postgres)

9.9.5. Delaying Execution

The following function is available to delay execution of the server process:

pg_sleep(seconds)

pg_sleep makes the current session's process sleep until seconds seconds have elapsed. seconds is a value of type double precision, so fractional-second delays can be specified. For example:

SELECT pg_sleep(1.5);

Note: The effective resolution of the sleep interval is platform-specific; 0.01 seconds is a common value. The sleep delay will be at least as long as specified. It might be longer depending on factors such as server load.

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：Date/Time Functions and Operators (Postgres)

关键词：post