JSON Export

To export the data from a table to a JSON file, use the COPY statement:

COPY tbl TO 'output.json';

The result of queries can also be directly exported to a JSON file:

COPY (SELECT * FROM range(3) tbl(n)) TO 'output.json';

{"n":0}
{"n":1}
{"n":2}

The JSON export writes JSON lines by default, standardized as Newline-delimited JSON. The ARRAY option can be used to write a single JSON array object instead.

COPY (SELECT * FROM range(3) tbl(n)) TO 'output.json' (ARRAY);

[
        {"n":0},
        {"n":1},
        {"n":2}
]

For additional options, see the COPY statement documentation.