Despite Postgres course, I am still unable to pass a list as parameter with WHERE statement.
Let say we want 10 item_id so that:
list_id = [0,1,2,3,4,5,6,7,8,9]
conn = psycopg2.connect... query = "SELECT * FROM table WHERE item_id = list_id;" pd.read_sql(query, con=conn)
Obviously it doesn’t work, but someone knows how to pass a list as parameter ? I searched on the Web, but I didn’t find clear solution working for me.