Hands-On RESTful Web Services with Go - Second Edition

Exploring the JSONStore feature in PostgreSQL

PostgreSQL >9.2 has a prominent feature called JSONStore. PostgreSQL introduced two new data types for 9.2">storing JSON data. PostgreSQL allows users to insert JSON data as a json field or a jsonb field. It is quite useful for modeling real-world data that has to be more flexible in its structure. PostgreSQL draws on the best of both worlds by allowing us to store JSON strings as well as relational types.

The main difference between json and jsonb is that the json field stores data as plaintext whereas jsonb stores that same data as a binary field. Each has its own benefits. For example, the json field commonly takes up less space than jsonb because it is a straightforward insert, but the jsonb ...