Json.dumps alternative in Redshift

164 Views Asked by Ayushi Bansal At 06 September 2022 at 20:07

I have strings like

Origi\"nal

and

Origi"nal

. I want to convert them to raw string and then to a Json String and write to a table in Redshift.

Example output of "select col from table" should be:

Origi\\\"nal
Origi\"nal

Can someone please suggest a way forward?

There are 0 best solutions below