Postgresql Jsonb
Learn This Powerful Tool By Example
Published on 31. January 2025
978-1-300-62143-0 (ISBN)
Description
An in-depth, by examples ,look to the forgotten powerful tool .The jsonb type,
We will learn 'Jsonb' type true usefulness when we have complex tables with complex columns that contains composite data types, where conventional build of columns is of no use , and use of 'Jsonb' is the solution.
In this book chapters we will get to know the:
1- Build of a jsonb .
2- The operators used in queries, and their uses.
3- How to run complex queries on columns with composite types.
4- How to run different types of functions on jsonb columns(creation, testing and processing functions).
5- Then we learn the powerful jsonb subscripting , that will makes complex data queries of composite types columns.. as easy as possible.
More details
Content
Chapter 1 :
* Types of json.
* Jsonb data types.
* Example of Jsonb types
* Jsonb Example.
Chapter 2 :
* Jsonb Operators
* Jsonb SELECT query.
* SELECT with join.
* Jsonb UPDATE query.
Chapter 3 :
* Jsonb Functions.
* Jsonb Indexes.
Chapter 4 :
* Jsonb Subscripting.
