PostgreSQL SELECT And INSERT

In today’s article, we will be talking about Using PostgreSQL SELECT and INSERT together.

First, let’s query the data in the table with the SELECT statement;

In the table above, we see that there are three records. Let’s add a record with the name “Nezih” and the surname “er” and working in the Software department, but let’s do it with select.

The plpgsql above (we can think of it as a Postgresql language) also shows that a record has been added to the table.

Let’s check this with the SELECT statement.

As you can see in the picture above, our Nezih record has been successfully added.