Re: [sqlalchemy] How to query postgresql JSONB columns?

Am 05.04.2015 01:58 schrieb Mike Bayer mike...@zzzcomputing.com: On 4/4/15 7:47 PM, Daniel Kerkow wrote: 2015-04-05 1:29 GMT+02:00 Mike Bayer mike...@zzzcomputing.com: On 4/4/15 7:22 PM, Daniel Kerkow wrote: Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have

[sqlalchemy] How to query postgresql JSONB columns?

Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have the following model using JSONB data type in PostgreSQL. The JSON data looks like {'key1': 'value1', 'key2': 'value2'} The Docs are relatively sparse regarding this topic. How can I query the properties column for containing

Re: [sqlalchemy] How to query postgresql JSONB columns?

2015-04-05 1:29 GMT+02:00 Mike Bayer mike...@zzzcomputing.com: On 4/4/15 7:22 PM, Daniel Kerkow wrote: Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have the following model using JSONB data type in PostgreSQL. The JSON data looks like {'key1': 'value1', 'key2