[postgis-users] load more than one shape files to one table?

Stephen Woodbridge woodbri at swoodbridge.com
Mon Nov 13 11:00:39 PST 2006


Thomas Zuberbuehler wrote:
> hello
> 
> i have more than 150 shape files with routes (every one contains one
> route). can i load this files to postgis and *only* one table which
> contains all routes? there could be a problem: a shape file contains
> more than one multilines.
> 
> shapefile type: arc
> postgis type: multilinestring[2]
> 
> someone has an idea?

shp2pgsql has an option to create just the table.

To run it once to create the table, then run it 150 times for your 
shapefiles but don't have it do the table create.

-Steve



More information about the postgis-users mailing list