Re: [sqlite] Import zipped csv file

On 4/6/18, gwenn wrote: > Hello, > Is it possible to mix zipfile and csv extensions ? > sqlite> SELECT data FROM zipfile('csv_file.zip'); > works. > sqlite> .shell unzip csv_file.zip > sqlite> CREATE VIRTUAL TABLE test USING csv(filename='csv_file.csv'); > works. > How to

[sqlite] Import zipped csv file

Hello, Is it possible to mix zipfile and csv extensions ? sqlite> SELECT data FROM zipfile('csv_file.zip'); works. sqlite> .shell unzip csv_file.zip sqlite> CREATE VIRTUAL TABLE test USING csv(filename='csv_file.csv'); works. How to pass the data extracted by zipfile to csv extension ? Thanks.