Python/psycopg2 WHERE IN statement

by

For the IN operator, you want a tuple instead of list, and remove parentheses from the SQL string.

# using psycopg2
data=('UK','France')

sql="SELECT * from countries WHERE country IN %s"
cur.execute(sql,(data,))

During debugging you can check that the SQL is built correctly with

cur.mogrify(sql, (data,))

More Related Contents:

  1. pg_config executable not found
  2. psycopg2: insert multiple rows with one query
  3. Pandas read_sql with parameters
  4. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  5. Passing table name as a parameter in psycopg2
  6. How to install psycopg2 with “pip” on Python?
  7. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  8. error installing psycopg2, library not found for -lssl
  9. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  10. How to set up a PostgreSQL database in Django
  11. How can I use psycopg2.extras in sqlalchemy?
  12. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  13. Psycopg2 image not found
  14. Can’t install psycopg2 with pip in virtualenv on Mac OS X 10.7
  15. psycopg2 installation error – Library not loaded: libssl.dylib
  16. Error Installing Psycopg2 on MacOS 10.9.5
  17. SQLAlchemy: engine, connection and session difference
  18. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  19. Create a Postgres database using python
  20. psycopg2 TypeError: not all arguments converted during string formatting
  21. Python/postgres/psycopg2: getting ID of row just inserted
  22. Escape SQL “LIKE” value for Postgres with psycopg2
  23. How to set connection timeout in SQLAlchemy
  24. How to quote a string value explicitly (Python DB API/Psycopg2)
  25. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found
  26. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  27. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  28. Insert Python Dictionary using Psycopg2
  29. Use binary COPY table FROM with psycopg2
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment