Closed SvanteRichter closed 2 years ago
sqlite will happily accept stdin if you tell it .import /dev/stdin {tablename}. For example this works just fine:
.import /dev/stdin {tablename}
gzip -dc icons.csv.gz | sqlite3 ':memory:' -csv '.import /dev/stdin data' '.output /dev/stdout' '.headers on' "SELECT name, keywords from data where name = 'chart-area'" | gzip - > icons2.csv.gz
sqlite will happily accept stdin if you tell it
.import /dev/stdin {tablename}. For example this works just fine:gzip -dc icons.csv.gz | sqlite3 ':memory:' -csv '.import /dev/stdin data' '.output /dev/stdout' '.headers on' "SELECT name, keywords from data where name = 'chart-area'" | gzip - > icons2.csv.gz