id variable in postgres [duplicate]

Question

This thing is working:

my_cursor.execute("SELECT word FROM words WHERE id = 45")

How can I make this thing working?

my_id = 45
my_cursor.execute("SELECT word FROM words WHERE id = my_id")

Assuming psycopg2 the docs spell it out Passing parameters — Adrian Klaver
– Adrian Klaver, Commented Aug 15, 2022 at 17:23
my_cursor.execute(f"SELECT word FROM words WHERE id = {my_id}") with modern string formatting. — Trenton McKinney
– Trenton McKinney, Commented Aug 15, 2022 at 18:05

Silvio Mayolo · Accepted Answer · 2022-08-15 17:23:22Z

2

In Python's Postgres library, you can interpolate values with %s and pass them as secondary arguments to execute.

my_cursor.execute("SELECT word FROM words WHERE id = %s", (my_id,))

answered Aug 15, 2022 at 17:23

Silvio Mayolo

70.9k6 gold badges91 silver badges139 bronze badges

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

1 Answer 1