Resources

JSON Export

duckdb.org

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 tbl) TO 'output.json'; For additional options, see the COPY statement documentation.

Visit Site

Resources duckdb.org