Insert error while inserting data to PostgreSQL with python psycopg2

Question

 try:
            for i in (0, nCount):
                query = "INSERT INTO students (Name, ID, Birth) VALUES (%s %d %d);"
                data = ('Y', 2, 9)
                cur.execute(query, data)
                conn.commit()

 except:
            print("I can't INSERT into students")

Connect to database and select operation are work but insert operation is not.
I use PostgreSQL and pgAdmin4
And create database use pgAdmin4
The DB structure is Name(text), Id(integer), Birth(integer)

-------------------------------------------------------------------------
Solve
* Change type of all columns to text (not text[]).
* Change column name in DB to small letter.

Sam Chats · Accepted Answer · 2017-07-04 06:11:21Z

1

From my best knowledge you missed , in values clause. I think you need write smthng like values (%s,%d,%d)

edited Jul 4, 2017 at 6:11

Sam Chats

2,3211 gold badge14 silver badges36 bronze badges

answered Jul 4, 2017 at 4:54

Vasyl Moskalov

4,6403 gold badges24 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert error while inserting data to PostgreSQL with python psycopg2

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related