Timeline for How can I execute SpatiaLite commands directly from the command line?

11 events

when toggle format	what		by	license	comment
May 7, 2021 at 15:22	vote	accept	raylight
May 7, 2021 at 5:23	comment	added	wingnut		See answer below. Headers and CSV are command line options. zetcode.com/db/sqlite/tool shows this further down the page.
May 7, 2021 at 5:21	answer	added	wingnut		timeline score: 2
May 7, 2021 at 5:07	answer	added	Spacedman		timeline score: 2
May 7, 2021 at 2:41	history	edited	Vince	CC BY-SA 4.0	naming
May 7, 2021 at 2:19	comment	added	raylight		@wingnut Cool, it accepts the query as its second parameter after the database name. So the solution was simple: `spatialite data.sqlite "select * from table" > file.csv`... The only remaining issue is a way of including the header on the file without using `.headers on`. Although I can do it directly on the shell before writing the data to the file.
May 7, 2021 at 2:14	comment	added	wingnut		zetcode.com/db/sqlite/tool shows some command line options. Maybe try reading this first and having a few attempts.
May 7, 2021 at 2:12	history	edited	raylight	CC BY-SA 4.0	added 188 characters in body
May 7, 2021 at 2:04	comment	added	raylight		@wingnut I guess in sqlite3 the procedure would be the same... But it's not clear to me how I can do it.
May 7, 2021 at 2:01	comment	added	wingnut		sqlite3 should work, shouldn't it?
May 7, 2021 at 1:59	history	asked	raylight	CC BY-SA 4.0