If you look at the omnisci architecture,
omnisci_serv can recall some of the metadata to configure a table or column.
One such example is to access sql with $OMNISCI_PATH/bin/omnisql.
You can enter the omnisql> \d (table name) or \t command to view all tables and table columns that are stored.
Is there any way or instruction to check only the table name, column, and bounding box values corresponding to geometry?
If I have to check it in a different way, how should I check it?
Hi @g_star,
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.*
test_table
test_table_fsi
test_table_fsi_gz
test_table_fsi_s
if you want the one that ends with gz
omnisql> \t .*gz
test_table_fsi_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;
name
Arizona
Colorado
New Mexico
Texas
Oklahoma
Utah
6 rows returned.
Execution time: 79 ms, Total time: 80 ms
Regards
Candido