[PDF] create table and insert data postgres

How to create a table in PostgreSQL and insert data?

Use INSERT INTO statement to insert one or more rows into a table in PostgreSQL.
INSERT INTO <table-name> (<column1>, <column2>,) VALUES (<value1>, <value2>,) RETURNING * or <column_name>; Use the INSERT INTO clause with the table-name where you want to insert the data.

How do I insert data into an already created table?

Basic INSERT syntax
INSERT INTO table_name (column1, column2, column3,etc) VALUES (value1, value2, value3, etc); The first line of code uses the INSERT statement followed by the name of the table you want to add the data to.
After the table name, you should specify the column names.

How to create a new table in postgres?

Summary

How to create a new table in postgres?

Copying Data Between Tables