Getting column is of type jsonb[] but expression is of type text[] when trying to insert with psycopg2

Question

I'm using execute_values to insert the content of many tables on other tables, I already set the adapter of dict to json when I received other error, however I don't know how to treat this one:

psycopg2.ProgrammingError: column "rules" is of type jsonb[] but expression is of type text[] LINE 1: ...UES (1,'tturxvrtgvvsrqgzsedcoyqujakyepjordrbbjdw',ARRAY['{"i...

The only way to handle that was something like this issue, but I would need to treat each column ...

Maybe there are ways to create a new adapter, but I couldn't achieve how to do that by the docs.

register_adapter(dict, Json)

execute_values(
            dest_cursor,
            f'''
            INSERT INTO {t} VALUES %s ON CONFLICT DO NOTHING;
            ''',
            records,
    )

Is there a automatic way to deal with that, like the register_adapter?

Felipe Augusto · Accepted Answer · 2019-05-02 19:46:52Z

2

I've found the answer by this issue I learned I could use the template parameter, like so:

execute_values(
  dest_cursor,
  f'''
  INSERT INTO {t} VALUES %s ON CONFLICT DO NOTHING;
  ''',
  records,
  template="(%s, %s, %s::jsonb[], %s, %s)" # as many placeholders requested
)

answered May 2, 2019 at 19:46

Felipe Augusto

8,22413 gold badges43 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting column is of type jsonb[] but expression is of type text[] when trying to insert with psycopg2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related