steampipe-sqlite icon indicating copy to clipboard operation
steampipe-sqlite copied to clipboard

enable query or list of vtables

Open judell opened this issue 1 year ago • 3 comments

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

judell avatar Nov 28 '23 23:11 judell