开发者

PostgreSQL how to query json data based upon json attribs criteria

开发者 https://www.devze.com 2023-03-19 21:49 出处:网络
I am using PostgreSQL i want to store JSON data into table column. La开发者_如何转开发ter i want to retrieve data records criteria based upon JSON attributes.

I am using PostgreSQL i want to store JSON data into table column. La开发者_如何转开发ter i want to retrieve data records criteria based upon JSON attributes. I know sort of this support available in MS SQL Server but i don't know that is it available in PostgreSQL or not.


How about using hstore and formatting it to JSON with these formatting functions?


Yes, take a look at json-datatype project from Google Summer of Code 2010 (especially check json.html) and this answer.

0

精彩评论

暂无评论...
验证码 换一张
取 消