Auto import csv to Postgres

import_csv.py

import csv
import sys
import subprocess

with open(sys.argv[1], 'rb') as csvfile:
    reader = csv.reader(csvfile)
    header_row = reader.next()

    cmd1 = "psql -U you dbname -c 'CREATE TABLE " + sys.argv[2] + " ("
    for idx, column in enumerate(header_row):
        cmd1 += column + " text"
        if idx != len(header_row) - 1:
            cmd1 += ", "

    cmd1 += ")'"

    subprocess.call(cmd1, shell=True)

    cmd2 = "psql -U you dbname -c \"COPY " + sys.argv[2] + " FROM '" + sys.argv[1] + "' DELIMITER ',' CSV HEADER\""

    subprocess.call(cmd2, shell=True)

python import_csv.py ~/my-awesome-csv.csv awesome_csv_table

Hi @jczaplew does this automatically imports a new CSV next time python starts up? as CSV could be uploaded while Python is not running?