How to insert JSON data in PostgreSQL
If you have a JSON dataset that you need to insert into PostgreSQL, this video showcase how you can perform it with a SQL statement.
00:00 Intro
00:13 Check the JSON data
00:32 Create the table containing the JSON(B) column
01:08 Insert the JSON data
01:53 What if the JSON is not correct?
02:29 Summary
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...
