Once you have created your table with the necessary specifications, the next logical step is of course to fill the table with data. There are generally three methods in PostgreSQL with which you can fill a table with data:

  • Use the INSERT INTO command with a grouped set of data to insert new values.

  • Use the INSERT INTO command in conjunction with a SELECT statement to insert existing values from another table.

  • Use the COPY (or \copy ) command to insert values from a system file.