python adds “E” to string

by

To pass identifiers to postgresql through psycopg use AsIs from the extensions module

from psycopg2.extensions import AsIs
import psycopg2
connection = psycopg2.connect(database="db", user="user")
cur = connection.cursor()
cur.mogrify(
    'CREATE USER %s PASSWORD %s', (AsIs('someuser'), AsIs('somepassword'))
    )
'CREATE USER someuser PASSWORD somepassword'

That works also for passing conditions to clauses like order by:

cur.mogrify(
    'select * from t order by %s', (AsIs('some_column, another column desc'),)
    )
'select * from t order by some_column, another column desc'

More Related Contents:

  1. How to write DataFrame to postgres table
  2. CS50: LIKE operator, variable substitution with % expansion
  3. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  4. SQLAlchemy create_all() does not create tables
  5. Can’t subtract offset-naive and offset-aware datetimes
  6. error installing psycopg2, library not found for -lssl
  7. Django JSONField inside ArrayField
  8. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  9. django.db.utils.OperationalError Could not connect to server
  10. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  11. Composite primary key in django
  12. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  13. How do you join two tables on a foreign key field using django ORM?
  14. Connection problems with SQLAlchemy and multiple processes
  15. How to upsert pandas DataFrame to PostgreSQL table?
  16. Error Installing Psycopg2 on MacOS 10.9.5
  17. Pyodbc – “Data source name not found, and no default driver specified”
  18. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  19. Strange SQLAlchemy error message: TypeError: ‘dict’ object does not support indexing
  20. Case insensitive unique model fields in Django?
  21. Django JSONField filtering
  22. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  23. How to find pg_config path
  24. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  25. How to set connection timeout in SQLAlchemy
  26. Deploying Django to Heroku (Psycopg2 Error)
  27. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  28. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  29. Insert Python Dictionary using Psycopg2
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment