Working with JSON/JSONB
JSON vs JSONB
| JSON | JSONB |
|---|---|
| Stores exact copy | Binary format |
| Preserves whitespace | No whitespace |
| Preserves key order | Keys sorted |
| Slower queries | Faster queries |
| No indexing | Supports GIN indexes |
0:00
0% complete
LearnStep 1 of 2
JSON/JSONB in PostgreSQL
Learning Objectives
- •Use JSONB columns
- •Query JSON data
- •Update JSON fields
Lesson Outline
LearnStep 1/2
JSON/JSONB in PostgreSQL
python
Inserting JSON Data
python
Querying JSON Data
python
Updating JSON
python
JSONB Indexing
python