postgresqlHow do I insert data into a PostgreSQL database?

The following example shows how to insert data into a PostgreSQL database using the INSERT statement:

INSERT INTO table_name (column1, column2, column3)
VALUES (value1, value2, value3);

Code explanation

**

• INSERT INTO: This is a keyword used to indicate that data is being inserted into the database.
• table_name: This is the name of the table that the data will be inserted into.
• column1, column2, column3: This is a list of the columns that the data will be inserted into.
• VALUES: This is a keyword used to indicate the values that will be inserted into the columns.
• value1, value2, value3: This is a list of the values that will be inserted into the columns.

## Helpful links

• PostgreSQL Documentation - Insert
• PostgreSQL Tutorial - Insert

Edit this code on GitHub