Failed to insert into postgresql table

Question

I am using this to create table:

dbconn=psycopg2.connect("dbname='postgres' host='localhost' port='5432' user='postgres' password='123456'")
cur=dbconn.cursor()
cur.execute("""
CREATE TABLE Person
(
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
""")

But when I try to insert into the database with this:

>>> cur.execute("""INSERT INTO Persons (LastName,FirstName,Address,City) VALUES ('%s','%s','%s','%s');""",("aa","bb","cc","dd"))

This is what I get:

Traceback (most recent call last):
  File "<pyshell#42>", line 1, in <module>
    cur.execute("""INSERT INTO Persons (LastName,FirstName,Address,City) VALUES ('%s','%s','%s','%s');""",("aa","bb","cc","dd"))
ProgrammingError: syntax error at or near "aa"
LINE 1: ...rsons (LastName,FirstName,Address,City) VALUES (''aa'',''bb'...

You need to commit your transaction with dbconn.commit() otherwise your table won't get created. — Burhan Khalid
– Burhan Khalid, Commented Aug 15, 2013 at 7:47

roman · Accepted Answer · 2013-08-15 07:45:19Z

1

Shouldn't it be like this?

cur.execute("INSERT INTO Persons (LastName,FirstName,Address,City) VALUES (%s, %s, %s, %s);", ("aa", "bb", "cc", "dd"))

example from psycopg documentation:

>>> cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)",
...      (100, "abc'def"))

edited Aug 15, 2013 at 7:45

answered Aug 15, 2013 at 7:39

roman

118k30 gold badges205 silver badges209 bronze badges

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

1 Comment

sadaf2605 Over a year ago

Still it does not work! :(

Traceback (most recent call last):   File "<pyshell#13>", line 1, in <module>     cur.execute("INSERT INTO Person (LastName,FirstName,Address,City) VALUES (%s, %s, %s, %s);", ("aa", "bb", "cc", "dd")) InternalError: current transaction is aborted, commands ignored until end of transaction block

Collectives™ on Stack Overflow

Failed to insert into postgresql table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related