Hi, Is it correct to pass dummy tables that don't exist in database to ogr2ogr command. It seems to work, but I am not sure it will work going forward(I am currently using 1.9 most of the work and 2.0 for some of the new code). eg. I passed tables=tablename_that_does_not_exis (a dummy table name that does not exist) to following command. Note that I did not pass my_osm_data at all to tables parameter. Is that correct?
ogr2ogr -s_srs EPSG:4326 -t_srs EPSG:4326 -f "ESRI Shapefile" '/tmp/ab.shp' PG:"dbname=mydbname tables=tablename_that_does_not_exist" -sql " select * from my_osm_data limit 1" The reason I need to pass tables parameter is that without this the ogr2ogr is very slow. The db has large number of tables with geomtery columns and it seems to effectively query all geometry columns during startup. (And passing the actual set of tables used would require me to understand all the sqls). Thanks, Hemant.
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
