Delay or Wait-For Statement
Does pgsql have a waitfor statement like t-sql.
Yes, pg_sleep:
pg=> SELECT pg_sleep(10);
pg_sleep
----------
(1 row)
You could call the pg_sleep function with the PERFORM statement since we don't care about returning values:
PERFORM pg_sleep(10);