In case you omit an optional column, PostgreSQL will use the column default value for insert. If you omit required columns in the INSERT statement, PostgreSQL will issue an error. To insert character data, you enclose it in single quotes (‘) for example 'PostgreSQL Tutorial'. The statement returns the following output: INSERT 0 1 Code language: Shell Session ( shell ) VALUES( '', 'PostgreSQL Tutorial') Code language: SQL (Structured Query Language) ( sql ) The following statement inserts a new row into the links table: INSERT INTO links ( url, name) 1) PostgreSQL INSERT – Inserting a single row into a table In this tutorial, you just need to execute it to create a new table. Note that you will learn how to create a new table in the subsequent tutorial. ) Code language: SQL (Structured Query Language) ( sql ) The following statement creates a new table called linksfor the demonstration: DROP TABLE IF EXISTS links RETURNING output_expression AS output_name Code language: SQL (Structured Query Language) ( sql ) PostgreSQL INSERT statement examples For example: INSERT INTO table_name(column1, column2, …) To rename the returned value, you use the AS keyword followed by the name of the output. RETURNING id Code language: SQL (Structured Query Language) ( sql ) If you want to return just some information of the inserted row, you can specify one or more columns after the RETURNING clause.įor example, the following statement returns the id of the inserted row: INSERT INTO table_name(column1, column2, …) RETURNING * Code language: SQL (Structured Query Language) ( sql ) If you want to return the entire inserted row, you use an asterisk ( *) after the RETURNING keyword: INSERT INTO table_name(column1, column2, …) The INSERT statement also has an optional RETURNING clause that returns the information of the inserted row. The count is the number of rows that the INSERT statement inserted successfully. Typically, the INSERT statement returns OID with value 0. PostgreSQL used the OID internally as a primary key for its system tables. The INSERT statement returns a command tag with the following form: INSERT oid count The columns and values in the column and value lists must be in the same order. Second, supply a list of comma-separated values in a parentheses (value1, value2.First, specify the name of the table ( table_name) that you want to insert data after the INSERT INTO keywords and a list of comma-separated columns ( colum1, column2.VALUES (value1, value2, …) Code language: SQL (Structured Query Language) ( sql ) The following illustrates the most basic syntax of the INSERT statement: INSERT INTO table_name(column1, column2, …) The PostgreSQL INSERT statement allows you to insert a new row into a table. Introduction to PostgreSQL INSERT statement Summary: in this tutorial, you will learn how to use the PostgreSQL INSERT statement to insert a new row into a table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |