search

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

Skip internal indexes in .schema output #171

Closed mjpieters closed 7 months ago

mjpieters commented 8 months ago

See the schema table sql column documentation:

The sqlite_schema.sql is NULL for the internal indexes that are automatically created by UNIQUE or PRIMARY KEY constraints.

Fixes #170

amjith commented 7 months ago

Thank you! Is there a good email to contact you? I'd like to invite you to join as a core dev.

mjpieters commented 7 months ago

Thank you! Is there a good email to contact you? I'd like to invite you to join as a core dev.

I’m sorry, I’d have to decline the invitation. I’ve just, today, migrated the project I was using litecli with to PostgresSQL and I’m not likely to be of much help here.

amjith commented 7 months ago

That's too bad. We do have pgcli which can be of help if you liked the litecli UX. 😄