Read files within zip archives
Maintainer(s):
isaacbrodsky
Installing and Loading
INSTALL zipfs FROM community;
LOAD zipfs;
Example
SELECT * FROM 'zip://my_zip.zip/my_file.csv';
About zipfs
The zipfs extension adds support for reading files from within zip archives.
Added Settings
name | description | input_type | scope |
---|---|---|---|
zipfs_extension | Extension to look for splitting the zip path and the file path within the zip. To specify an artificial seperator, instead set: set zipfs_split = '!!'; |
VARCHAR | GLOBAL |
zipfs_split | Extension to look for splitting the zip path and the file path within the zip. Will be removed from the zip file name. Overrides zipfs_extension. Defaults to NULL. | VARCHAR | GLOBAL |