new tablespace parameter for shp2pgsql

[kneufeld]

I would like to see the addition of a tablespace parameter added to shp2pgsql.

For loading large tables, this is currently a three stage process.

• load DDL from shp2pgsql
• use psql and alter the tablespace of the table
• load the data from shp2pgsql

Postgres stores relations as individual files. When loading several thousand tables, the underlying OS can become slow when looking up a particular file/table. Having multiple tablespaces solves this problem.

[mcayland]

I guess that could be a useful feature; as a temporary work-around you could always use ALTER USER foo SET default_tablespace 'bar' and then load the shp2pgsql output as the foo user before reverting if required.

ATB,

Mark.