-
Notifications
You must be signed in to change notification settings - Fork 89
Open
Description
Is there a way to get --indent option to work when printing the schema for a table?
In sqlite3 prompt:
sqlite> .schema runstats --indent
CREATE TABLE IF NOT EXISTS "runstats"(
"id" INTEGER NOT NULL PRIMARY KEY,
"run_id" INTEGER NOT NULL,
"crate_id" INTEGER NOT NULL,
"functions" INTEGER,
"functions_converted" INTEGER CHECK(functions >= functions_converted),
"instances" INTEGER,
"instances_converted" INTEGER CHECK(instances >= instances_converted),
"instance_types" INTEGER,
"instance_types_converted" INTEGER CHECK(instance_types >= instance_types_converted),
FOREIGN KEY("run_id") REFERENCES "run"("id"),
FOREIGN KEY("crate_id") REFERENCES "crate"("id")
);
CREATE INDEX "runstats_run_id" ON "runstats"("run_id");
CREATE INDEX "runstats_crate_id" ON "runstats"("crate_id");
In litecli:
❯ litecli aunor.db
LiteCli: 1.11.0 (SQLite: 3.45.3)
GitHub: https://github.com/dbcli/litecli
aunor.db> .schema runstats --indent
Time: 0.000s
majutsushi
Metadata
Metadata
Assignees
Labels
No labels