[gdal-dev] ogr2ogr load shape in tablespace

[Even Rouault]

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