SQLAlchemy with Posgresql generates an unexpected result when using ilike ORM queries.... The strings that are returned on the fields which "ilike" queries are performed are returned in all lowercase despite being stored in the database with varied casing.

In this post I provide a query that generates SQL statements to easily index identifier columns in your postgresql database.

Need to replicate a MySQL database to Postgres? This blog covers all the steps to get this working.