id variable in postgres

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](https://www.psycopg.org/docs/usage.html#passing-parameters-to-sql-queries) — Adrian Klaver, Aug 15 '22 at 17:23
`my_cursor.execute(f"SELECT word FROM words WHERE id = {my_id}")` with **modern** string formatting. — Trenton McKinney, Aug 15 '22 at 18:05

score 2 · Accepted Answer · answered Aug 15 '22 at 17:23

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 '22 at 17:23

Silvio Mayolo

1 Answers1