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
More of Postgresql
- How do I use the PostgreSQL row_number function?
- How can I use PostgreSQL with YAML?
- How do I use PostgreSQL's XMLTABLE to parse XML data?
- How can I integrate PostgreSQL with Yii2?
- How can I use PostgreSQL with Zabbix?
- How can I use PostgreSQL for my project?
- How do I use a PostgreSQL XML parser in an example?
- How can I convert XML data to a PostgreSQL table?
- How do I export data from PostgreSQL to an XML file?
- How can I use the WHERE IN array clause in PostgreSQL?
See more codes...