How to check geometry table information in omnisql

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