SELECT * FROM some_table WHERE customer -> 'name' = 'Joe' Īssuming the some_table table has a JSON column named customer, this query will make PostgreSQL examine each row’s document, and return those rows where the name key is equal to “Joe”. At the most basic level, PostgreSQL supports the following: For JSON to really shine, we need to be able to ask for all JSON documents satisfying some condition - and to do it efficiently. JSON types have in part been the relational database response to the NoSQL movement, with its pervasive, schema-less JSON documents: look, we can do it too! But the marriage of a traditional relational schema with non-relational documents has proven very powerful indeed complex data no longer have to be represented via sprawling, relational models involving endless joins, and islands of fluid, schema-less content within a stricter relational model brought some very welcome flexibility.ĭatabase JSON support usually means that some operations on JSON data can be performed in the database after all, simply storing and loading JSON documents is quite useless in itself.
Most relational databases have had some sort of native support for JSON for quite a while now PostgreSQL introduced its first JSON support in version 9.2, back in 2012, and the more optimized jsonb type in 2014. EFCore 3.0 for PostgreSQL - Advanced JSON Support
0 kommentar(er)
