Edit this page

JSON Import

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

Query

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

Result

 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:

Query

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:

Query

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:

Query

COPY tbl FROM 'input.json';