Bookmarks tagged postgres and json

"9.16. JSON Functions and Operators # 9.16.1. Processing and Creating JSON Data 9.16.2. The SQL/JSON Path Language This section describes: functions …"

"Say you have a file that consists of one JSON document per line. How can you import it into a table easily? This is a problem I was called o..."

"I would like to import json data into postgres. The data I have is of the orders of a million rows, sizes are a minimum of 700 MB and stretches till 3 GB.
Here's a sample data I created based on the "

"For example I have a file customers.json which is an array of objects (strictly formed) and it's pretty plain (without nested objects) like this (what is important: it's already include ids):
[ ..."

"I am trying to see how to flatten the jsonb column titled "additionalFields" below. I can query the table with
SELECT "id","additionalFields" AS "additionalFields..."