The PostgreSQL INSERT INTO statement assures you to include
a new row in the table. A row or multiple rows can be inserted at the time of
the query results.
Syntax to use of INSERT INTO keyword in PostgreSQL
The original sentence of the INSERT INTO statement is as follows:
INSERT
INTO TABLE_NAME (column1, column2, column3,...columnN)
VALUES
(value1, value2, value3,...valueN);
|
Here, column 1, column 2, columns are columns in the table in which you want to insert the data.
The names of the target column can be listed in any order.
The value given by the price segment or the query is linked to the left or
right from a clear or built-in column list.
If you are adding values to all the columns in the table,
you may not need to specify the column (s) in the SQL query. However, undo
doubt that the order of values is in the same table in the table. The SQL
INSERT INTO syntax will be as follows-
INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);
|
Output explanation when Inserted records in the table -PostgreSQL
The following table explains the output message and their
purpose-
S.No.
|
Output message and representation
|
1
|
INSERT oid 1
The message was returned when only one row was inserted. OID is the statistical OID of the inserted
row.
|
2
|
INSERT 0 #
If several rows were entered, the message came back. # Contains the number of rows.
|
Illustration
Let us make the Employee table in myDB like this –
CREATE TABLE Employee(
ID INT PRIMARY KEY NOT NULL,
EmpName TEXT NOT NULL,
Age INT NOT NULL,
Address CHAR(50),
Salary REAL,
DOJ DATE
);
|
In the following instance, there is a line in the Employee's table –
INSERT INTO
Employee (ID, EmpName, Age, Address, Salary, DOJ)
VALUES (1, 'DK', 25, 'Noida', 20000.00,'2019-06-15');
|
The following instance is to include a line; The salary column has been left here and therefore its default value will be –
INSERT INTO
Employee (ID, EmpName, Age, Address, DOJ)
VALUES (2, 'Anil', 25, 'Delhi', '2018-12-13');
|
Instead of specifying the following example values, use the DOJ column for the DEFAULT clause –
INSERT INTO
Employee (ID, EmpName, Age, Address, Salary, DOJ)
VALUES (3, 'Ria', 23, 'Gkp', 25000.00, DEFAULT );
|
The following illustrations include several lines using multi-line syntax –
INSERT INTO
Employee (ID, EmpName, Age, Address, Salary, DOJ)
VALUES ('Sia',22, ‘Noida’ 65000.00, '2018-12-13'),
(5, 'Naina', 27, 'Delhi', 85000.00, '2018-06-15');
|