![]() WHERE info -> 'items' -> 'product' = 'Diaper' Code language: SQL (Structured Query Language) ( sql ) For example, to find out who bought Diaper, we use the following query: SELECT info -> 'customer' AS customer We can use the JSON operators in WHERE clause to filter the returning rows. And then info->'items'->'product' returns all products as text. ORDER BY product Code language: SQL (Structured Query Language) ( sql )įirst info -> 'items' returns items as JSON objects. For example, the following statement returns all products sold: SELECT info -> 'items' -> 'product' as product The following query uses the operator -> to get all customers in form of JSON: SELECT info -> 'customer' AS customerįROM orders Code language: SQL (Structured Query Language) ( sql )Īnd the following query uses operator -> to get all customers in form of text: SELECT info -> 'customer' AS customerīecause -> operator returns a JSON object, you can chain it with the operator -> to retrieve a specific node. The operator -> returns JSON object field by text.The operator -> returns JSON object field by key.PostgreSQL provides two native operators -> and -> to help you query JSON data. PostgreSQL returns a result set in the form of JSON. To query JSON data, you use the SELECT statement, which is similar to querying other native data types: SELECT info FROM orders Code language: SQL (Structured Query Language) ( sql ) VALUES( '') Ĭode language: SQL (Structured Query Language) ( sql ) Querying JSON data The following INSERT statement inserts a new row into the orders table. ![]() To insert data into a JSON column, you have to ensure that data is in a valid JSON format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |