How to update records in batch in postgresql
What this article shares with you is about how to update records in batches in postgresql. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.
The code is as follows:
CREATE FUNCTION updateTchrNm () RETURNS void AS
$body$
DECLARE
Rownum integer: = 1
BEGIN
While rownum
