Bulk Loading of Data into PostgreSQL Using the COPY Command

The following objectives are requied to complete this hands-on lab:

• The expenses table must be prepared by dropping any foreign keys and indexes.
• The data will be loaded into the expenses table from the CSV file location in /tpm/expenses.csv.
• After confirming the data was loaded properly, the foreign key should be added back to the expenses table.

Database Info

• User: postgres
• Database name: demo

The expenses.csv file will be downloaded into the /tmp/ directory. You can also access it here