Client Area

PostgreSQL Command: INSERT INTO

PostgreSQL Command: INSERT INTO

PostgreSQL is a powerful open-source relational database management system that offers a wide range of features and capabilities. One of the fundamental commands in PostgreSQL is INSERT INTO, which allows users to add new rows of data into a table. In this article, we will explore the syntax and usage of the INSERT INTO command in PostgreSQL.

Syntax

The basic syntax of the INSERT INTO command in PostgreSQL is as follows:

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

Here, table_name refers to the name of the table where the data will be inserted. The column1, column2, column3, ... represents the columns in the table where the data will be inserted. The VALUES keyword is followed by the corresponding values that will be inserted into the specified columns.

Example

Let’s consider a hypothetical table named employees with the following structure:

+----+-----------+----------+
| ID |  Name     |  Salary  |
+----+-----------+----------+
| 1  | John Doe  | 5000     |
| 2  | Jane Smith| 6000     |
+----+-----------+----------+

To insert a new employee into the employees table, we can use the INSERT INTO command as follows:

INSERT INTO employees (ID, Name, Salary)
VALUES (3, 'Mark Johnson', 5500);

This command will add a new row with the ID of 3, the name ‘Mark Johnson’, and a salary of 5500 into the employees table.

Inserting Multiple Rows

The INSERT INTO command also allows users to insert multiple rows of data in a single command. To achieve this, we can modify the syntax as follows:

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

Each set of values enclosed in parentheses represents a new row of data to be inserted into the table.

Summary

The INSERT INTO command in PostgreSQL is a crucial tool for adding new rows of data into a table. By following the syntax and examples provided in this article, you can effectively utilize this command to insert data into your PostgreSQL database.

For more information about VPS hosting services, consider checking out Server.HK. They offer reliable and high-performance VPS solutions to meet your hosting needs.