AI Academy
Promotion
CodeGym University
Learning
Courses
Tasks
Surveys & Quizzes
Games
Help
Schedule
Community
Users
Forum
Chat
Articles
Success stories
Activity
Reviews
Subscriptions
Light theme
Lessons
Reviews
About us
Start
Start learning
Start learning now
My Progress
Courses
University
Quest Map
Lessons
SQL
SQL
Level 33
Working with JSON and JSONB
SQL SELF
Level 33,
Lesson 0
Learn how to use the JSON and JSONB data types in PostgreSQL to store, search, and handle complex structured data. This article covers the differences between the formats, usage examples, and practical tips for picking the right type for your needs.
Comparing
JSON
and
JSONB
: Pros and Cons of Each Format
SQL SELF
Level 33,
Lesson 1
Find out what’s different between JSON and JSONB data storage formats in PostgreSQL, how they affect performance, indexing, and data processing, and when you should pick one or the other for your projects.
Extracting Data from JSON Objects
SQL SELF
Level 33,
Lesson 2
Learn how to pull data out of JSONB objects in PostgreSQL using operators and functions. Real-life examples, common mistakes, and tips for working with nested data structures.
Extracting Nested Data:
jsonb_to_recordset()
SQL SELF
Level 33,
Lesson 3
Learn how to use the
jsonb_to_recordset()
function in PostgreSQL to turn arrays of JSONB objects into table rows for easy filtering, aggregation, and data analysis. Real-life examples, common mistakes, and tips for working with nested structures.
Updating Data in JSON Objects Using
jsonb_set()
and
jsonb_insert()
SQL SELF
Level 33,
Lesson 4
Learn how to efficiently update and modify data inside JSONB objects in PostgreSQL using the
jsonb_set()
and
jsonb_insert()
functions. Real-life examples, common mistakes, and tips for working with nested structures.
Please enable JavaScript to continue using this application.