JSON Import

Search Shortcut cmd + k | ctrl + k

Documentation / Guides / File Formats

JSON Import

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

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

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

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:

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:

COPY tbl FROM 'input.json';