Monday , November 3 2025

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

PostgreSQL While Loop Statement

In this article, you will learn how to use PostgreSQL while loop statement to execute statements as long as a condition is true.

while condition loop
   statements;
end loop;

while condition loop

statements;

end loop;

For example:

The following example uses the while loop statement to display the value of a counter: