SQLite Forum

CLI manual could be clearer on which commands support pipes
Login

CLI manual could be clearer on which commands support pipes

(1) By ilkkachu on 2021-03-27 13:20:24 [link] [source]

The online manual [1] mentions in 7.1 and 7.2 that '.read' and output functions support pipes, but there's no mention of that under 7.5 and 7.6 about importing and exporting CSV files. However, pipes seem to work with '.import' too.

If using pipes with '.import' and '.export' is supported (and I can't see a reason why not), this could be mentioned under 7.5 and 7.6 too, even if as a brief reference to the earlier sections.

[1] https://www.sqlite.org/cli.html#redirecting_i_o and below

(2) By Larry Brasfield (larrybr) on 2021-04-01 18:58:42 in reply to 1 [source]

The .import command doc will be improved along the lines you suggest. (And thanks for the input.) The .output and .once redirection possibilities are already mentioned, under "Redirection". There is not yet a .export command.