<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
James,<br><br>By default, shp2psql creates a new table for each Shape file. Setting the option -a, appends the Shape file to an already existing table. Check http://postgis.refractions.net/documentation/manual-1.5/ch04.html#shp2pgsql_usage.<br><br>Regards,<br><br>Edward<br><br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">Date: Wed, 13 Jun 2012 13:56:13 -0700<br>From: butler.james1@gmail.com<br>To: postgis-users@postgis.refractions.net<br>Subject: [postgis-users] Loading Many .shp file into one table<br><br><div>
<div>How do I put many shape files into 1 table?</div>
<div> </div></div>
<div>The PostGIS plug-in shape file uploader makes one seperate table each time it uploads a shape file. </div>
<div> </div>
<br>_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users</div> </div></body>
</html>