Escape Python to `json[]` for `COPY FROM` PostgreSQL insertion?

Or when I try to json.dump the dict twice I get:
psycopg2.errors.InvalidTextRepresentation: malformed array literal: ""{"jj":null,"text":"bop"}"" DETAIL:  Array value must start with "{" or dimension information. CONTEXT:  COPY my_table, line 1, column json_arr_col: ""{"jj":null,"text":"bop"}""

I'm using your `copy_expert` function. PS: Also asked on https://stackoverflow.com/q/75511919

Am I meant to represent the lists with braces rather than square brackets? - Or should I be using some internal psycopg function as opposed to my hacked together `parse_col` function?

Thanks,

Samuel Marks

Charity | consultancy | open-source | LinkedIn