| CARVIEW |
Select Language
HTTP/2 200
date: Tue, 29 Jul 2025 03:20:18 GMT
content-type: text/html; charset=utf-8
cf-ray: 96697ac3df4dc1c9-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=0675ed5f-8ac1-45bb-a79e-a1c02dd5f12f; expires=Wed, 29 Jul 2026 03:20:17 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 4f08062b-77d1-422b-9bb3-6cced62b4cb7
x-worker-origin-response-time: 827000000
x-dns-prefetch-control: off
set-cookie: prov=0675ed5f-8ac1-45bb-a79e-a1c02dd5f12f; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=cKCgiolBbiTmfs5zTrIBJbgknnbw0QtW7n1KiZVPNbs-1753759218-1.0.1.1-Pfvbheji4OTqkhPfm3uturClY4GZR9QoOcDVFM8K_qn7Xq2lbCKY01HdKIeQALpczr8PctroAGEXtMXdpr.TqBLj7mTPbGI.Rc_rKY1YND0; path=/; expires=Tue, 29-Jul-25 03:50:18 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=ev1eXGPF2uOM72GTdxmhyaDsrnbhrkySvGOzr.AQqA8-1753759218110-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'jsonb' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [jsonb]
For questions about using the `jsonb` data type. The primary database language that supports `jsonb` is PostgreSQL.
61 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
5
votes
2
answers
1k
views
What does 'b' stand for in PostgreSQL's JSONB data type?
While not a technical question per se, I'm curious about the actual meaning of b in PostgreSQL's jsonb data type.
I skimmed through the official documentation but I couldn't figure it out. As far I ...
3
votes
1
answer
370
views
Why does a Json Path inequality over an array not work?
Given the following jsonb array, I want to filter it only for certain objects.
[
{
"id": "123"
},
{
"id": "456"
},
{
"id": "...
1
vote
1
answer
52
views
SELECT with array values on WHERE using postgres
I'm using an query to update a object array inside a jsonb column.
Example data:
[
{
"_id": "68696e0a3aab2f9ff9c40679",
"altura": 1,
"comprimento":...
2
votes
1
answer
207
views
JSONB vs JSON for column-oriented data in PostgreSQL
I am processing data tables with varying numbers of columns and rows, represented by JSON documents with one array per column. The format of a document is
{
"column_1": ["value_1_1&...
0
votes
0
answers
52
views
Are multi column indexes for JSONB columns better?
we are using PostgreSQL and we have a table we are using JSONB due to the unstructured nature of the data. We are integrating with a ton of different CRMs, so a part of the records data is pretty ...
0
votes
1
answer
135
views
How to build an efficient EAV model over JSONB in Postgresql
Context
Hello, we have a project we integrate with a ton of different CRMs. That means that when a new client comes in, we get all their data from their CRM and store it in our own postgresql database....
1
vote
1
answer
116
views
Optimize query by telling Postgres to scan records from the most recent to the oldest
I am using Postgres 12 and in my app I have a table that I am using to store specific events that contain information about things that happened outside of the system and related to some records in my ...
0
votes
1
answer
92
views
How to Index/Query JSONB Columns with Arbitrary Keys for Efficient Membership Queries in PostgreSQL?
In Postgres, how do I properly index/query jsonb columns that only contain key-value pairs where the keys are arbitrary, to speed up membership operations?
I have a table structured like this:
CREATE ...
1
vote
2
answers
1k
views
Does LZ4 compression have an effect on JSONB columns?
After doing some experimentation, it appears as though COMPRESSION lz4 doesn't have any effect on JSONB columns (whereas it does for JSON, and TEXT). Is that indeed the case? If so, why is that?
I ...
-1
votes
1
answer
46
views
POSTGRES : Data import
DB Version : 13.x
Source table schema\
CREATE TABLE mig_bus_data
mig_id SERIAL,
mig_data JSONB
Target table schema\
CREATE TABLE BUSINESS
id UNIQUE SERIAL,
data1 <TYPEx>...
1
vote
1
answer
289
views
will null-ing JSONB column in postgres table before performing ALTER TABLE DROP of that column help?
I changed table structure and I am about to remove old JSONB column from about 2.5M rows big table.
The JSONB makes this table really big - pg_total_relation_size: 408GB
Performing ALTER TABLE ... ...
0
votes
1
answer
2k
views
Computing hashes in PostgreSQL for JSONB columns
From PostgreSQL docs:
jsonb does not preserve white space, does not preserve the order of object keys, and does not keep duplicate object keys. If duplicate keys are specified in the input, only the ...
1
vote
1
answer
1k
views
EAV or JSONB column for dynamic data that needs good indexing
I have some data in a Postgres database that does not fit into a static schema. There is a table "content" and each piece of content has a user-defined type. Each type can have different ...
2
votes
0
answers
306
views
like_regex vs jsonb_build_object performance
I'm working with Postges 14.8 and using JSONB to store data.
The queries that I'm working with perform filtering and JOIN'ing based on stuff in this JSONB column named data. We need to perform JOIN's ...
1
vote
1
answer
778
views
How do you sum **sub-elements** of a JSON field?
In PostgreSQL, how do you sum sub-elements of a JSON field?
Given: Customer <--- Order
where Order has a JSON field quantities_per_product that contains the qty and shipped qty for each product of ...
- The Overflow Blog
-
- Featured on Meta
-
-
Related Tags
postgresql × 56
json × 15
json-path × 9
query × 4
index × 3
postgresql-14 × 3
plpgsql × 3
database-design × 2
array × 2
aggregate × 2
eav × 2
group-by × 2
performance × 2
update × 2
where × 1
temporal-tables × 1
sum × 1
spatial × 1
psql × 1
postgresql-9.6 × 1
postgresql-13 × 1
import × 1
more related tags
Hot Network Questions
- What are ways to prevent overly long ballots?
- Writing a visually-selected couple of files out to a file with an open buffer
- How does one justify the rationality of buying insurance?
- An SF novel where a very young child escapes being murdered by hiding in the water tank of a toilet
- Leibniz's monadology and free will
- PoE center tap vs dedicated V+/V-
- Has the Silver Surfer's clothing (or lack thereof) ever been addressed in the comics?
- Ignore the last line of a file when using `\VerbatimInput`
- Who has faced the country of winning and losing?
- word category and coordination
- Can the Passion effect of Dementation be used to suppress the feelings associated with the blood bond?
- What is the outcome when an officer's statement under oath contradicts video evidence
- The puzzle of chess pieces beating one another in “rock—paper—scissors” way
- Film or TV series about powerful man who is banished, fishes beings he creates from ponds
- Expected Cards Left When One Color Is Exhausted
- Why do we name and separate invisible bands even though the EM spectrum is continuous?
- Is there any way to make lines in \rule have round corners?
- I struggle to draft without editing
- Near-future novel where a teacher transfers bodies with an assassin
- Efficient extraction of first/only key in a dictionary
- DIY cleaning of an old wooden sculpture
- Extract archives within archives using 7zip CLI
- Why does power drop occur when the buzzer is activated?
- Is the six million dollar hut challenge real?