SQLite User Forum

Chain Commands in Sqlite: .print dot-command not Working
Login

Chain Commands in Sqlite: .print dot-command not Working

(1) By blueray453 on 2022-07-03 08:30:53 [link] [source]

I am using version 3.31.1

I can chain commands in sqlite like:

$ sqlite3 test.sqlite .tables .schema "select * from object_store"`

However, when I try to use `.print` dot-command, it gives error.

$ sqlite3 test.sqlite .print "The Tables Are:" .tables
Error: near "The": syntax error

How to print string when chaining commands in sqlite?

(2) By Stephan Beal (stephan) on 2022-07-03 08:48:21 in reply to 1 [source]

How to print string when chaining commands in sqlite?

$ sqlite3 test.sqlite ".print 'The Tables Are:'" .tables

(3) By blueray453 on 2022-07-03 11:21:17 in reply to 2 [link] [source]

Thank you very much.