sqlalchemy/psycopg2 desreializes my jsons as dicts but doesn't preserve order

Viewed 408

I have a psql query that returns a json object. I fetch this query with results.fetchall() and I get the json properly as a dict. however, as I'm in python 3.4, not yet in 3.6, the objects' order is not preserved in the dict. I saw there's a way to use OrderedDict to keep the order of the json but I'm not sure how to tell sqlalchemy/psycopg2 to use it.

can anybody help please?

1 Answers
Related