Hello,
I'm testing out the jsonb functionality on postgres 9.4 and up. I added
an extension to sqlalchemy which enables nicer jsonb access through the
orm and extends support for all the query types:
http://docs.sqlalchemy.org/en/rel_0_9/dialects/postgresql.html?highlight=json#sqlalchemy.dialects.postgresql.JSON
The psycopg2 driver doesn't recognise jsonb yet however and results
don't get run through json.reads.
According to http://schinckel.net/2014/05/24/python,-postgres-and-jsonb/
the oid and typarray are 3802 and 3807 respectively.
Are there any plans to add jsonb support to psycopg2, and/or is someone
working on this already?
Thanks!
Damian
