Postgresql – Stripping out newline characters from input JSON string when using COPY Command in Postgres
I have a set of code that is importing a JSON file provided into a temp table as follows: DROP TABLE IF EXISTS tmp; CREATE TEMP table tmp (c JSONB ); sqltxt:='COPY tmp from '''||filepath||''' with (FORMAT TEXT, DELIMITER ''~'')';…