Le jeudi 12 septembre 2013 14:26:13, Clay, Bruce a écrit : > I need to load a set of shapefiles into a tablespace (on a different hard > drive) where I have more dataspace. I have been using ogr2ogr to load > shapefile up to this point using windows command prompt and batch files. > I created a tablespace using pgAdminIII but I can not find a way to assign > the data to the tablespace from ogr2ogr. I googled but did not find a way > to do so. > > Is there a way not listed in the help function or docs?
Bruce, I'm just discovering what tablespaces are from the PostgreSQL docs. There's no direct way of doing this currently, although it doesn't look very complicated to add support for that. But you can probably workaround that by using the pgdump driver ogr2ogr -f pgdump out.sql your.shp and then edit out.sql to add at its very beginning : SET default_tablespace = your_tablespace; and then insert the SQL with the following command (can possibly also be done with pgAdmin3 I imagine) psql -d XXXXX -f out.sql I've not actually tried the above however. Even -- Geospatial professional services http://even.rouault.free.fr/services.html _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
