mattn/go-sqlite3

get "near ".": syntax error" when query ".tables"

himcc opened this issue · 2 comments

himcc commented

code : https://gist.github.com/himcc/3fc0268cb395eda620d55d29ba87d355

What's wrong?

How can i get tables name and schema?

.tables is not SQL syntax (obviously). .tables is implemented by the SQLite shell, not by the database itself. Instead do:

SELECT name FROM sqlite_master WHERE type="table"

https://github.com/rqlite/rqlite/blob/master/cmd/rqlite/main.go#L154

himcc commented

.tables is not SQL syntax (obviously). .tables is implemented by the SQLite shell, not by the database itself. Instead do:

SELECT name FROM sqlite_master WHERE type="table"

https://github.com/rqlite/rqlite/blob/master/cmd/rqlite/main.go#L154

Thank you very much