The Art of PostgreSQL/

...

/

Challenge: JSON Data Type

Challenge: JSON Data Type

Try a hands-on exercise to test your knowledge of JSON data types.

We'll cover the following...

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
...