The following table summarizes the output messages and their meaning − INSERT INTO TABLE_NAME VALUES (value1,value2,value3.valueN) The SQL INSERT INTO syntax would be as follows −
However, make sure the order of the values is in the same order as the columns in the table. You may not need to specify the column(s) name in the SQL query if you are adding values for all the columns of the table. The values supplied by the VALUES clause or query are associated with the explicit or implicit column list left-to-right. The target column names can be listed in any order. Here, column1, lumnN are the names of the columns in the table into which you want to insert data. INSERT INTO TABLE_NAME (column1, column2, lumnN) Syntaxīasic syntax of INSERT INTO statement is as follows −
One can insert a single row at a time or several rows as a result of a query.
The PostgreSQL INSERT INTO statement allows one to insert new rows into a table.
