search

rsyi / whale

🐳 The stupidly simple CLI workspace for your data warehouse.
https://rsyi.gitbook.io/whale
GNU General Public License v3.0
723 stars 39 forks source link

Surface index info for relation databases #132

Open peterthesling opened 3 years ago

peterthesling commented 3 years ago

For postgres, mysql, and other relational DBs, we’re not surfacing or scraping index information in any way, which could be useful for those on these sorts of DBs to see. Robert found a nice stack question (https://stackoverflow.com/questions/2204058/list-columns-with-indexes-in-postgresql) that gives rough queries on how to do this in postgres. It seems that the markdown rendering part probably needs to be refactored first.

peterthesling commented 3 years ago

I'll start working on this in the next days.