steampipe-sqlite
steampipe-sqlite copied to clipboard
enable query or list of vtables
This comes up empty:
sqlite> select * FROM sqlite_master WHERE type='table';
Is there another way to list out the vtables we provide?
Of course there's always the hub. And if I know I have e.g. github_issue I can do this:
sqlite> pragma table_info('github_issue');
0|repository_full_name|TEXT|0||0
1|number|INT|0||0
2|id|INT|0||0
3|node_id|TEXT|0||0
4|active_lock_reason|TEXT|0||0
5|author|TEXT|0||0
Still it would be nice if we populated sqlite_master.
sqlite> pragma table_info('sqlite_master');
0|type|TEXT|0||0
1|name|TEXT|0||0
2|tbl_name|TEXT|0||0
3|rootpage|INT|0||0
4|sql|TEXT|0||0