Bzip2

The bzip2 driver decompresses a local Bzip2 file and opens the contents with the matching data driver.

URL format

bzip2://<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 'bzip2://people.csv.bz2?quote=%22' -- 'SELECT * FROM people;'

Usage notes

Keep the original extension before .bz2 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.