0

There are 7 fields: id - char img - char phone - char date-date gender-char address_id - foreign key user_id - foreign key

I have written a script to load this in the postgres db, looks something like this:

conn = psycopg2.connect(user="user",
                        password="data",
                        host="",
                        port="5432",
                        database="")
cur = conn.cursor()


def load_data_on_db():
    with open(r'C:\Users\Documents\user.csv', 'r') as f:
        reader = csv.reader(f)

        #next(reader)  # Skip the header row.
        for row in reader:
            cur.execute(
                'INSERT INTO "CollectData_userdetails" VALUES (%s,%s,%s,%s,%s,%s,%s)',row)
        conn.commit()


load_data_on_db()

Throws an error

'INSERT INTO "CollectData_userdetails" VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s)',row)

TypeError: not all arguments converted during string formatting

Improve this question
2
  • Is that not a duplicate ? stackoverflow.com/questions/40344690/… Commented Oct 17, 2019 at 11:43
  • it didnot work for me... throws no error but nothing gets loaded to the db Commented Oct 18, 2019 at 4:58
Related questions
0
how to dump CSV data into postgresql table using python
34
copy data from csv to postgresql using python
0
Read a CSV to insert data into Postgres SQL with Python
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.