Skip to content

--indent with .schema doesnt work #179

@the-shank

Description

@the-shank

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions