Challenge: JSON Data Type
Explore PostgreSQL's JSON data type by creating a cars table, inserting JSON-formatted car details, retrieving specific records, and updating JSON fields. Understand how to manage denormalized data with hands-on SQL tasks and learn to manipulate JSON data efficiently.
Problem statement
You will perform the following tasks to check your understanding of JSON data type.
Task 1
Create a table cars with two columns and insert the following data:
| car_id | car_info |
|---|---|
| 1 | brand: ferrari, model: testarosa |
| 2 | brand: aston martin, model: db2 |
| 3 |