Some catalog to querying using SQL table names, columns, and so on.
in the meantime, you can use reg hex expressions to filter tables with \t command of omnisci
so if you want to get a list of tables that start with test_table you can type
omnisql> \t test_table.*
if you want the one that ends with gz
omnisql> \t .*gz
And so on. regular expressions are compelling, and you can do almost anything
about columns, right now there isn’ìt anything to search for them; I developed a show columns for table like ‘column name’ command,’ but I’m not sure if is the feature you are looking for, and it’s not
to filter existing geometries with a bounding box, you have to query each table using the st_dwinthin function
omnisql> select name from omnisci_states where ST_DISJOINT(omnisci_geo,ST_GeomFromText('polygon ((-111.652 39.1009, -102.350 39.1009, -102.350 32.647, -111.652 32.647))',4326)) is false;
6 rows returned.
Execution time: 79 ms, Total time: 80 ms