Dimitri Fontaine: Exporting a Hierarchy in JSON: with recursive queries

Published: 31/01/2018
Dimitri Fontaine: Exporting a Hierarchy in JSON: with recursive queries
Source: POSTGR.ES

In another article here, entitled on JSON and SQL , we saw in great details how to import a data set only available as a giant JSON file. Then we normalized the data set, so as to be able to write SQL and process our data. This approach is sometimes very useful and was a good way to learn some of the JSON functions provided by PostgreSQL. In this article, we’re going to use SQL to export the

Read more
Related news
Comment