[Live Demo] Query JSON Data In Postgres Database | JSONB Data Type In Postgresql

You will learn how to handle json data in postgres and run queries to fetch json data, specific json attributes and apply filters on json attributes in postgresql.

GITHUB CODE URL

Limeguru Website:

LimeGuru YouTube Channel

Limeguru Facebook Page

[ramonventoso]

Excellent! Topic is very well presented and organized. Thank you!

[jesuschal]

So good introduction for me evaluating MongoDB vs PostgreSQL!!!

[vc]

Simple and clear explanation !!! Good examples !!! Thanks :-)

[maverickgee]

I always like limeguru... Detailed explanation.. thankyou

[clarinetist]

This is very helpful! Thank you so much!!

[rajgohil]

It's very helpful thanks for this wonderful example

[Alexander-iseq]

Thank you so much! It’s best tutorial on youtube!

[salmankashfy]

Thats really awesome. Thanks. There should be array of objects filtering as well

[mrkamranumer]

Very Well Explained, Big Thumb for your wonderful effort

[basheerraad]

Here I found what I needed. useful video

[JanacMeena]

6:00 jsonb_array_elements
9:00 Containment operator

[Yankzy]

Great video, my question is: How to INSERT INTO or UPDATE json column such that after I insert others, the data in the column will look like

{
"2021-08-10":{...},
"2021-08-11":{...},
....
}

[pothurusudheer-mmjw]

Every one talk about select or insert. But what about modifying multiple values in that json column in a table

[learnandearnit]

How do you do this type of array of json i.e. {"postId": 234, "author": [{"id": 2, "name": "James"}, {"id": 3, "name": "James"}] }. How do we handle unknown array index. instead of doing author->0->>'id'?

[swwa]

How do I declare json variable and use it as table

[sushmithachavanchavan]

Using CDL.ToJSONArray, Ive a json array string after reading csv file, . How to use this to insert into a table in postgres?

[suryapratapsingh]

What about sorting on JSON data ? Is it possible?

[ganeshpatidar]

How do I query if I have date field in data json.

[yomajo]

Why no update? Seems there are issues updating JSON fields with sqlalchemy.

[jayachandraB]

how to update if I have jsonb object like '[1, "abac", 3, 4]' can you please help. I wan to replace some value inside the list