JSON Import

To read data from a JSON file, use the read_json_auto function in the FROM clause of a query:

SQL

SELECT *FROM read_json_auto('input.json');

 id | name  | value
----+-------+-------
  1 | alpha |    10
  2 | beta  |    20

To create a new table using the result from a query, use CREATE TABLE AS from a SELECT statement:

SQL

CREATE TABLE new_tbl AS    SELECT *    FROM read_json_auto('input.json');

To load data into an existing table from a query, use INSERT INTO from a SELECT statement:

SQL

INSERT INTO tbl    SELECT *    FROM read_json_auto('input.json');

Alternatively, the COPY statement can also be used to load data from a JSON file into an existing table:

SQL

COPY tbl FROM 'input.json';