dbcli / litecli

CLI for SQLite Databases with auto-completion and syntax highlighting
https://litecli.com
BSD 3-Clause "New" or "Revised" License
2.06k stars 67 forks source link

.schema: line breaks and missing index information #149

Open balta2ar opened 1 year ago

balta2ar commented 1 year ago

sqlite:

→ sqlite3 imdb-cmudb2022.db
SQLite version 3.37.2 2022-01-06 13:25:41
Enter ".help" for usage hints.
sqlite> .schema people
CREATE TABLE people (
  person_id VARCHAR PRIMARY KEY,
  name VARCHAR,
  born INTEGER,
  died INTEGER
);
CREATE INDEX ix_people_name ON people (name);
sqlite>

litecli:

→ litecli imdb-cmudb2022.db
Version: 1.9.0
Mail: https://groups.google.com/forum/#!forum/litecli-users
GitHub: https://github.com/dbcli/litecli
imdb-cmudb2022.db> .schema people
+--------------------------------------------------------------------------------------------------------------+
| sql                                                                                                          |
+--------------------------------------------------------------------------------------------------------------+
| CREATE TABLE people (\n  person_id VARCHAR PRIMARY KEY,\n  name VARCHAR,\n  born INTEGER,\n  died INTEGER\n) |
+--------------------------------------------------------------------------------------------------------------+
Time: 0.012s
imdb-cmudb2022.db>