On jeudi 13 avril 2017 18:52:58 CEST Vautour, André (INT) wrote: > Hi all, > > I started playing with the Oracle Spatial (OCI) vector driver and was > surprised that the default behaviour is to look for all the tables listed > in ALL_SDO_GEOM_METADATA. > > I would have expected it to use all the tables in the schema (user) that was > provided, so, essentially, to query USER_SDO_GEOM_METADATA. I think it > would make sense to support only listing the tables in a given schema. > > Assuming that the default behaviour is to remain unchanged, I am considering > a couple of options: > > 1. Add something like a LIST_ONLY_USER_TABLES dataset open option, > which would query USER_SDO_GEOM_METADATA instead of ALL_SDO_GEOM_METADATA. > > 2. Add a SCHEMA dataset open option which would query > ALL_SDO_GEOM_METADATA WHERE OWNER = '<value_of_option>' > > 3. Add wildcard support to the tables list, so that a user can specify > something like <a_schema>.*,<another_schema>.*
André, In the PostgreSQL driver, we have <Option name="SCHEMAS" type="string" description="Restricted sets of schemas to explore (comma separated)" /> Sothat would be something close to your 3. Even -- Spatialys - Geospatial professional services http://www.spatialys.com
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
