📄️ File Formats
📄️ CSV Export
To export the data from a table to a CSV file, use the COPY statement:
📄️ CSV Import
To read data from a CSV file, use the read_csv function in the FROM clause of a query:
📄️ Excel Export
Goose supports exporting data to Excel .xlsx files via the excel extension. Please note that .xls files are not supported.
📄️ Excel Import
Goose supports reading Excel .xlsx files. However, .xls files are not supported.
📄️ File Access with the file: Protocol
Goose supports using the file
📄️ JSON Export
To export the data from a table to a JSON file, use the COPY statement:
📄️ JSON Import
To read data from a JSON file, use the readjsonauto function in the FROM clause of a query:
📄️ Parquet Export
To export the data from a table to a Parquet file, use the COPY statement:
📄️ Parquet Import
To read data from a Parquet file, use the read_parquet function in the FROM clause of a query:
📄️ Directly Read Goose Databases
Goose allows directly reading Goose files through the read_goose function:
📄️ Directly Reading Files
Goose allows directly reading files via the readtext and readblob functions.