Postgres JSON Support

Comments discuss PostgreSQL's JSON and JSONB features for storing, querying, and indexing semi-structured data, often recommending it as an alternative to NoSQL databases like MongoDB.

📉 Falling 0.3x Databases
3,362
Comments
18
Years Active
5
Top Authors
#4867
Topic ID

Activity Over Time

2009
14
2010
18
2011
24
2012
152
2013
206
2014
209
2015
227
2016
232
2017
215
2018
215
2019
208
2020
232
2021
291
2022
250
2023
387
2024
301
2025
174
2026
7

Keywords

e.g ON CSV index.php stricttables.html LINQ TABLE EAV SQL XML json postgres postgresql functions document querying columns sql tables array

Sample Comments

marz0 Jun 13, 2020 View on HN

Have you considered using Postgres with JSONB?

nailer Sep 3, 2019 View on HN

The comment you're replying to mentions that Postgres can do JSON.

weberc2 Jun 19, 2017 View on HN

Postgres and probably others support JSON these days.

jaequery Sep 3, 2019 View on HN

Why not just use Postgres, set a field as jsonb, done?

GiorgioG Oct 25, 2018 View on HN

I'm guessing you're already aware, but for anyone that isn't - Postgres supports JSON as well https://www.postgresql.org/docs/10/static/datatype-json.html

masklinn May 13, 2013 View on HN

the json support is fairly recent and doesn't support operating directly on the data yet (e.g. you have to create functional indexes through plv8js and you can't directly query on the document's content as you can with array, xml or hstore columns)

wewewedxfgdf May 16, 2025 View on HN

Postgres has very sophisticated JSON querying and storage.

Beefin Apr 10, 2020 View on HN

have you tried using the postgres json data type? it's a joke.

arcticfox Jul 10, 2018 View on HN

Right, but you could just build that in Postgres with JSONB

kstrauser Dec 19, 2018 View on HN

Would PostgreSQL + JSONB work for you there?