JSON export, exports JSON data incorrectly

[AdrianJMartin]

After building a query which returns data as JSON, using the export as JSON converts the row data to a string and adds escapes

Screenshots

[mmcfarland]

Thanks @AdrianJMartin -- good catch. I'll look into this and get a fix started.

[mmcfarland]

Hi @AdrianJMartin, this has been fixed in v1.19.0 (pre-release). Exporting results as JSON should no longer double-encode JSON/JSONB column values. Could you give it a try and let us know if the output looks correct now?