Below you will find pages that utilize the taxonomy term “COPY”
How to JSON in PostgreSQL®
read more
How to load JSON data in PostgreSQL with the COPY command
You have a JSON dataset that you want to upload to a PostgreSQL table containing properly formatted rows and columns… How do you do it?
All the main sources like my own blog and others tell you to load the JSON in a dedicated temporary table containing a unique JSON
column, then parse it and load into the target table. However there could be another way, avoiding the temp table!