Zstandard

The zstd driver decompresses a local Zstandard file and opens the contents with the matching data driver.

URL format

zstd://<file>[?<format-options>]

Options

There are no decompression-specific query options. Query parameters are forwarded to the detected data driver; for example, CSV accepts has_header, quote, and skip_rows.

Examples

rsql --url 'zstd://people.csv.zst?quote=%22' -- 'SELECT * FROM people;'

Usage notes

Keep the original extension before .zst so the decompressed filename identifies the data format. The corresponding format driver must be enabled. For CSV content, see CSV options. Decompressed data is staged in a temporary directory; queries do not rewrite the compressed source.

Use .tables to inspect the resulting tables.