How to write an array of dictionaries to JSONB?

Question

Python

Tell me, I have formed an array of dictionaries and I want to put this array in a JSONB field. How to do it?

Answer 1

From documentation :

from psycopg2.extras import Json

data = [
    {'a': 1},
    {'b': 2},
    {'c': 3, 'z': None}
]

curs.execute("insert into mytable (jsondata) values (%s)", [Json(data)])