5 ways to extract JSON data in PostgreSQL
If you have a JSON (or JSONB) data in PostgreSQL this video will show you all the methods to extract the data via SQL.
The video covers:
00:00 Intro
00:14 Check the data
00:53 Extract the JSON item with the Arrow operator
01:59 Nesting Arrow operator and extracting from arrays
03:00 Extract the JSON item as text with the double Arrow operator
03:41 Extracting using the # operator
04:52 Difference between Arrow operator and # operator for nested objects
06:00 Extracting using subscripting
06:24 Extracting using the jsonb_extract_path function
06:45 Summary
For more information, and examples check https://ftisiot.net/postgresqljson/ho...
Want to try? Check out Aiven for PostgreSQL FREE tier JSON_EXTRACT https://go.aiven.io/francesco-signup
Want to optimise your PostgreSQL SQL? Check Aiven AI Database Optimiser https://aiven.io/solutions/aiven-ai-d...
