jouet db schema

• Usage: jouet db schema [FLAGS] [TABLE]

List the tables with their columns, keys and indexes, or one table in full

Every table and view, one line each: columns with their types, pk, not null, defaults and -> table(column) foreign keys, then the table's indexes. Cut to --budget, with the names of the tables left out. Postgres's own schemas and partitions are left out.

With TABLE, that table alone, a column a line, with the foreign keys that point at it and its row count: exact when counting takes under half a second, else Postgres's estimate (~).

Exits 3 when TABLE does not exist.

Examples: jouet db schema jouet db schema users --url app.db jouet db schema billing.invoices

Arguments

• [TABLE] — One table or view to describe: NAME or SCHEMA.NAME

Flags

• --url <URL> — The database: a SQLite file, or a Postgres URL (default: DATABASE_URL)
• --remote — Allow a Postgres host that is not this machine
• --budget <BYTES> — The most bytes to print (default 8000; 0 is no limit)
• -h --help — Print help