Python Pandas - Write Very Large CSV file to (postgresql) SQL DB

pd_csv2sql.py

import pandas as pd
from sqlalchemy import create_engine

# Your connection string format may vary by SQL flavor;
con = f'postgresql://{username}:{password}@{host}:5432/{database}'
eng = create_engine(con)

# Open csv file as stream and write to SQL, appending as you go:
for chunk in pd.read_csv('filename.csv', chunksize = 1000):
    chunk.to_sql(name = 'giant_table',
                 con = eng,
                 if_exists = 'append')