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 files and other archives.
Added Functions
This extension does not add any functions.
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases |
|---|---|---|---|---|
| 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 | [] |