CSV to PostgreSQL Bulk Loader

import psycopg2, csv, io

def csv_to_postgres(filepath: str, table: str, conn_str: str):
    with open(filepath, newline="") as f:
        reader = csv.reader(f)
        headers = next(reader)
        buf = io.StringIO()
        writer = csv.writer(buf)
        for row in reader:
            writer.writerow(row)
        buf.seek(0)

    with psycopg2.connect(conn_str) as conn:
        with conn.cursor() as cur:
            cur.copy_expert(
                f"COPY {table} ({",".join(headers)}) FROM STDIN WITH CSV",
                buf,
            )
        conn.commit()
        print(f"Loaded into {table}")