python - How do I take only specified required columns from CSV file and add into a table in postgresql?

Question

Consider I have

*----*------*-----------*----------*----------*---------------*----------------*
| id | name | addressid | address1 | address2 | attendancekey | attendancedate |
*----*------*-----------*----------*----------*---------------*----------------*

columns in CSV file and I want only

1. id, name to be imported in student table and

2. addressid, address1, address2 to be imported in address table and

3. attendancekey and attendancedate to be imported in attendance table in database.

What query to be used to import the required columns into the table?

Database Postgresql Version - 12

Python Version - 3.4.4

Psycopg2 Version - 2.7.5

Answer 1

You will first have to COPY the data to a (perhaps UNLOGGED) staging table and populate the tables from there.

Alternatively, you can define a file_fdw foreign table on the CSV file (which has to be located on the database server machine) and use that to fill the tables. This would save you temporarily loading the file into the database.