test=# SELECT pg_sleep(10) In my example I use pg_sleep to just make the system wait for 10 seconds.
www.cybertec-postgresql.comwww.commandprompt.com
security.stackexchange.com
You can use pg_sleep() and pg_sleep_for() to delay 10 seconds as shown below according to Delaying Execution SELECT pg_sleep_for('10 seconds')
stackoverflow.comPostgreSQL Sleep Function pg_sleep – Postgres Delay Execution. 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.
www.if-not-true-then-false.comgithub.com
SELECT pg_sleep(10) For example, we can connect to the database that has a lower threshold and sleep for 4 seconds, which should trigger a log line: \c helloprisma. SELECT pg_sleep(4)
www.prisma.iodatabase.guide
pg_sleep ( double precision ) pg_sleep_for ( interval ) pg_sleep_until ( timestamp with time zone ). In particular, pg_sleep_until is not guaranteed to wake up exactly at the specified time, but it will not wake up any earlier.
www.postgresql.orgSELECToid::regclass FROM pg_class, pg_sleep(10) WHERE relkind = 'r'. Можно поместить вызов pg_sleep() в раздел SELECT
www.pvsm.ru