Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hello, does anyone know why the PostgresFetch task returns a json string's key value pairs with single quotes instead of double quotes?

I don’t know but the task is really simple. It’s just an `execute` <https://github.com/PrefectHQ/prefect/blob/d527ab2af11956d0564efbd8543989eab5a981ee/src/prefect/tasks/postgres/postgres.py#L75-L91|call> . Do you think something needs to be added?

Closed issue here <https://github.com/psycopg/psycopg2/issues/190>

image.png

As I understand, psycopg converts the json to a python object and parses.  A simple solution looks to be to cast the column as text in the query to avoid this parsing operation which will return the json key/value pairs in double quotes.