Handling JSON
Baji Shaik, Dinesh Kumar Chemuduru · Apress eBooks · 2023
In the previous chapter, we talked about arrays and how to use them in PL/pgSQL with some examples. In this chapter, we will discuss about JSON data and how to use it in PostgreSQL. We will cover different use cases where JSON data is useful and built-in operators and functions which are used to load and query JSON data. We will go through a few examples of JSON with PL/pgSQL programming.