[Python] psycopg2 insert python dictionary as jsonb

The question is identical to psycopg2 insert python dictionary as json except the psql column is a jsonb instead of json.

If I try to insert a python dict directly using psycopg2, I get the error can't adapt type 'dict', but it works when I wrap json.dumps around the python dict.

Is there a native way for psycopg2 to be able to handle this directly for me? I suspect that, if it exists, will be more performant than using the json package.

Continue reading...