This script can be used to copy a CSV file (with header) to a Postgres remote database.

copy_csv_to_db.py

#!/usr/bin/env/python

import psycopg2

# Get a database connection
dsn = "dbname=%s user=%s password=%s host=%s port=%s" % ('db_name','username','password','remote_host_ip','port')
conn = psycopg2.connect(dsn)

query = "COPY public.hiringpattern_new FROM stdin WITH CSV HEADER DELIMITER as ',' "
fp = open('csv_file_path', 'r')
cur = conn.cursor()
cur.copy_expert(sql=query, file=fp)
conn.commit()
cur.close()
fp.close()