Search Shortcut cmd + k | ctrl + k
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 tbl) TO 'output.json';

For additional options, see the COPY statement documentation.

About this page

Last modified: 2024-03-02