3 ms·
JSON is just a TEXT data type with validation, while HSTORE stores the data in a structured way and allows a more flexible indexing and such stuff. OTOH it's ju
by pgaddict 12y ago
JSON is just a TEXT data type with validation, while HSTORE stores the data in a structured way and allows a more flexible indexing and such stuff. OTOH it's just text=>text while JSON format allows additional data types.
That changed with JSONB, which got introduced in 9.4 - that's essentially HSTORE2, with additional improvements.