Search Shortcut cmd + k | ctrl + k
zipfs

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