PostgreSQL Assert Statement

In this article, you will learn about the PostgreSQL assert statement and how to use it for debugging purposes.

Although the assert command is similar to the RAISE command, its uses are different.

In the assert command, unlike raise, we need to put a condition and write the message we want to print by placing a “,” sign after this condition, and print the error message on the screen when the specified condition is not met.

In the plpgsql command below, if there is no record of 1005 in the movies table, “There is no movie with id 1005 in the table. Check your table.” We want an error like this to be returned.