Python: how to Insert value into table postgresql?

Question

how to format the string to insert it into a table in postgresql? example I have the sql:

req="INSERT INTO table_a values('%s','%s','%s','%s')"

and the values

values=["Socit d'Invest Variable", '6465', 'hg', 'fk_id']
cursor.execute(req,tuple(values))

I get the error :

psycopg2.ProgrammingError: syntax error at or near "Socit"
LINE 1: ...column0, column1, column2, column3) Values (''Socit d'Invest...

any Idea how to change the string from using a single quote ' to a double quote " ?

What version of psycopg2 are you using? It should automatically escape it for you. Have a look at the example from the docs: initd.org/psycopg/docs/… — freakish
– freakish, Commented Mar 30, 2015 at 10:00
it's an error in the quote when formating string look at the answer — m3asmi
– m3asmi, Commented Mar 30, 2015 at 10:06

m3asmi · Accepted Answer · 2015-03-30 10:08:18Z

2

the error was in the req

req="INSERT INTO table_a values('%s','%s','%s','%s')"

must be without quote '

req="INSERT INTO table_a values(%s,%s,%s,%s)"

answered Mar 30, 2015 at 10:08

m3asmi

1,2721 gold badge17 silver badges36 bronze badges

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

Comments

Paul Lo · Accepted Answer · 2015-03-30 09:32:53Z

0

I think you need to use backslash to escape your singlequote in the string for executing query correctly, so either use:

values = ['Socit d\'Invest Variable', '6465', 'hg', 'fk_id']

or

values = ["Socit d\'Invest Variable", '6465', 'hg', 'fk_id']

should be working

answered Mar 30, 2015 at 9:27

Paul Lo

6,1466 gold badges33 silver badges37 bronze badges

@m3asmi How about use req="INSERT INTO table_a values(%s,%s,%s,%s)" ?

@m3asmi Nice! I should have noticed that earlier :p