python + psycopg2.errors.SyntaxError: syntax error at end of input

Question

I'm getting this error message

 cursor.execute(query, variables)
psycopg2.errors.SyntaxError: syntax error at end of input

My code

data = {
    'country': data['country'][x],
    'year': data['year'][x].astype(float),
    'month': data['month'][x].astype(float)
}
db_connection.execute(
    f"""
    INSERT INTO my_table (country, year, month) VALUES (%(country)s, %(year)s, %(month)s) ON CONFLICT (country, year, month)
    """,
    data,
)

TerryA · Accepted Answer · 2022-12-02 23:35:23Z

2

You're missing a conflict_action in your sql statement. See https://www.postgresql.org/docs/current/sql-insert.html#:~:text=ON%20CONFLICT%20DO%20NOTHING%20simply,can%20perform%20unique%20index%20inference. for details.

EG You might want ON CONFLICT (country, year, month) DO NOTHING

answered Dec 2, 2022 at 23:35

TerryA

60.2k11 gold badges122 silver badges148 bronze badges

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

Collectives™ on Stack Overflow

python + psycopg2.errors.SyntaxError: syntax error at end of input

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related