💾 Archived View for freeshell.de › tldr › textql.gmi captured on 2022-06-11 at 23:52:37. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2022-04-28)

-=-=-=-=-=-=-

textql

Execute SQL against structured text like csv or tsv files.

More information.

textql -sql "{SELECT * FROM filename}" {path/to/filename.csv}
textql -dlm=tab -sql "{SELECT * FROM filename}" {path/to/filename.tsv}
textql -dlm={delimiter} -header -sql "{SELECT * FROM filename}" {path/to/filename.csv}
cat {path/to/file} | textql -sql "{SELECT * FROM stdin}"
textql -header -sql "SELECT * FROM {file1} JOIN {file2} ON {file1}.{c1} = {file2}.{c1} LIMIT {10}" -output-header {path/to/file1.csv} {path/to/file2.csv}
textql -output-dlm={delimiter} -output-header -sql "SELECT {column} AS {alias} FROM {filename}" {path/to/filename.csv}
Copyright © 2014—present the tldr-pages team and contributors.
This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

CC-BY