Re: [sqlite] Import zipped csv file

[Richard Hipp]

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 pass the data extracted by zipfile to csv extension ?
> Thanks.

I don't think that can be done right now.  It will require an
enhancement to the csv virtual table.  I have your request.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Import zipped csv file

[gwenn]

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.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users