Escape Python to `json[]` for `COPY FROM` PostgreSQL insertion?
| От | Samuel Marks |
|---|---|
| Тема | Escape Python to `json[]` for `COPY FROM` PostgreSQL insertion? |
| Дата | |
| Msg-id | CAMfPbcbOoC0k2CoSDo1jR-nh98N5qs_aU1T9hEXYpMfpQb-bZA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Escape Python to `json[]` for `COPY FROM` PostgreSQL insertion?
Re: Escape Python to `json[]` for `COPY FROM` PostgreSQL insertion? Re: Escape Python to `json[]` for `COPY FROM` PostgreSQL insertion? |
| Список | psycopg |
How do I insert into a table with a `json[]` column using the `COPY FROM` syntax?
Error:
psycopg2.errors.InvalidTextRepresentation: malformed array literal: "{"jj":null,"text":"bop"}"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"}""
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
В списке psycopg по дате отправления: