PostgreSQL – INSERT INTO Query

To insert a row into PostgreSQL table, you can use INSERT INTO query with the following syntax.

</>
Copy
INSERT INTO table_name(
	column1, column2,.., columnN)
	VALUES (value1, value2,.., valueN);

where

  • table_name is the name of table in which you would like to insert the row.
  • column1, column2,.., columnN are the columns of the table.
  • value1, value2,.., valueN are the respective values of the columns.

Example 1 – INSERT INTO table

In the following example, we are inserting an entry into students table of mydb database.

</>
Copy
 INSERT INTO students(
    id, name, age)
    VALUES (1, 'Jack', 24);
PostgreSQL INSERT INTO Query

Under the Messages, we got that INSERT Query returned successfully.

You can verify if the row is inserted to table, by selecting the rows of the table.

PostgreSQL INSERT INTO Table

Yes, the row is inserted to the table.

Example 2 – INSERT multiple rows into table in a single query

We can also insert multiple rows into PostgreSQL table using a single query. All you have to do is, provide multiple rows after VALUES keywork in the INSERT query as shown below.

</>
Copy
INSERT INTO students(
	id, name, age)
	VALUES (2, 'Wick', 22), (3, 'Tom', 19), (4, 'Jason', 23);

Here we have three rows to be inserted in a single query.

PostgreSQL Insert multiple rows into table in a single INSERT query

When you run this query, three rows would be inserted into the table.

PostgreSQL INSERT INTO table

Conclusion

In this PostgreSQL Tutorial, we learned to insert one or more rows into PostgreSQL table.