PostGIS Uploader - Need Many .shp files in One table

Question

How do I put many shape files into 1 table?

The PostGIS plug-in shape file uploader makes one seperate table each time it uploads a shape file.

Answer 1

There's a tool called pgShapeLoader, which allows you to specify the table to which you want the shape loaded. I downloaded OpenGeo 2.0.1, and it came with it. I'm not sure if you can get it anywhere else, but if you can lay your hands on OpenGeo Suite, the tool is bundled in it.

Have a look at this link: http://workshops.opengeo.org/postgis-intro/loading_data.html. It shows a screenshot of the tool. And, if you can follow the workshop tutorials, you'll probably get a link somewhere to download it.

You can also use Quantum GIS' SPIT tool (accessible via Database - Spit menu). After adding a shape file to load into PostGIS, you have an option to specify DB Relation Name, which can be the same as what you had used before. Of course with the assumption that you are using PostGIS.

Answer 2

you can achive this with some batch scripting:

for %i in (*.shp) do 
shp2pgsql -W Latin5 -s 4326 -I -S -D %i %~.shp myTableName | psql
          -U postgres -h localhost -d myDatabase

i hope it helps you...