<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:16px"><div id="yui_3_16_0_1_1440080626878_23197">This works for me:</div><div id="yui_3_16_0_1_1440080626878_17046"><br></div><div id="yui_3_16_0_1_1440080626878_23196">Create the SQL for the insert:<br></div><div dir="ltr" id="yui_3_16_0_1_1440080626878_16987">$ shp2pgsql -I shape.shp <tableName> >shapefile.sql<br></div><div id="yui_3_16_0_1_1440080626878_16899"><br><span></span></div><div id="yui_3_16_0_1_1440080626878_17072"><span id="yui_3_16_0_1_1440080626878_17107">Then insert that sql:</span></div><div dir="ltr" id="yui_3_16_0_1_1440080626878_17080"><span id="yui_3_16_0_1_1440080626878_17084">$ psql -d <database> -f shapefile.sql <br class="" id="yui_3_16_0_1_1440080626878_17083"></span></div><div id="yui_3_16_0_1_1440080626878_17106" dir="ltr"><br><span id="yui_3_16_0_1_1440080626878_17084"></span></div><div id="yui_3_16_0_1_1440080626878_17105" dir="ltr"><span id="yui_3_16_0_1_1440080626878_17084"></span></div><div id="yui_3_16_0_1_1440080626878_16900"> </div><div id="yui_3_16_0_1_1440080626878_16901" class="signature">If life gives you lemons, keep them-- because hey.. free lemons.
"~heart~ Sticker" fixer: http://microflush.org/stuff/stickers/heartFix.html</div><br> <div id="yui_3_16_0_1_1440080626878_16904" style="font-family: times new roman, new york, times, serif; font-size: 16px;"> <div id="yui_3_16_0_1_1440080626878_16903" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1440080626878_16902" dir="ltr"> <hr id="yui_3_16_0_1_1440080626878_16948" size="1"> <font id="yui_3_16_0_1_1440080626878_16905" face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> Rémi Cura <remi.cura@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion <postgis-users@lists.osgeo.org> <br><b><span style="font-weight: bold;">Cc:</span></b> PostGIS Users <postgis-users@googlegroups.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, August 19, 2015 11:00 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] How can I upload .shp files?<br> </font> </div> <div id="yui_3_16_0_1_1440080626878_16949" class="y_msg_container"><br><div id="yiv9155546056"><div id="yui_3_16_0_1_1440080626878_16951"><div id="yui_3_16_0_1_1440080626878_16950" dir="ltr">Other options : <br clear="none">
Grass gis<br clear="none">
Gdal <br clear="none">
Gdal-python<br clear="none">
Cheers<br clear="none">
Rémi</div>
<div id="yui_3_16_0_1_1440080626878_17001" class="yiv9155546056gmail_quote">Le 19 août 2015 09:51, "Elmehdi OUADOUD" <<a id="yui_3_16_0_1_1440080626878_17012" rel="nofollow" shape="rect" ymailto="mailto:ouadoud.elmehdi@gmail.com" target="_blank" href="mailto:ouadoud.elmehdi@gmail.com">ouadoud.elmehdi@gmail.com</a>> a écrit :<br clear="none"><blockquote id="yui_3_16_0_1_1440080626878_17000" class="yiv9155546056gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="qtdSeparateBR"><br><br></div><div class="yiv9155546056yqt4494242481" id="yiv9155546056yqt24882"><div id="yui_3_16_0_1_1440080626878_16999" dir="ltr">Hi <div id="yui_3_16_0_1_1440080626878_16998"><br clear="none"><div id="yui_3_16_0_1_1440080626878_23198">You have 3 solutions:</div><div id="yui_3_16_0_1_1440080626878_23204"><br clear="none"></div><div id="yui_3_16_0_1_1440080626878_17011">1-Use QGIS specialy PostGIS Manager and import your shp files to database;</div><div>2-Use PostGIS plugin PostGIS shapefile Import/Export Manager;</div><div id="yui_3_16_0_1_1440080626878_17003">3-Use shp2pgsql command</div><div><br clear="none"></div><div><br clear="none"></div><div id="yui_3_16_0_1_1440080626878_17009"><br clear="none"><br clear="none">Le mercredi 5 août 2015 04:50:58 UTC+2, Joao Bosco Jares a écrit :<blockquote id="yui_3_16_0_1_1440080626878_17008" class="yiv9155546056gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex;"><div id="yui_3_16_0_1_1440080626878_17007" dir="ltr">Hi All,<div id="yui_3_16_0_1_1440080626878_17006"><br clear="none"></div><div id="yui_3_16_0_1_1440080626878_23227">I know that can sounds weird this thread. but if we are talking about a popular data base, we need to meet a way to upload .shp file to post gis using an API, batch files seems a terrible workaround. I tried Rjava but nothing, I tried GISserver, but his .war is not working. So, I don't know what I can do anymore. Any advice are very welcome.</div><div><br clear="none"></div><div id="yui_3_16_0_1_1440080626878_23229">Ps.: I'm using Java/Spring, if anyone knows a efficient solution to deal with this architecture are very welcome too.</div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="none"></div><div>Thanks in advance.</div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="none"></div><div>Cheers</div></div></blockquote></div></div></div></div><br clear="none">_______________________________________________<br clear="none">
postgis-users mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:postgis-users@lists.osgeo.org" target="_blank" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br clear="none"></blockquote></div></div></div><br><div class="yqt4494242481" id="yqt89686">_______________________________________________<br clear="none">postgis-users mailing list<br clear="none"><a shape="rect" ymailto="mailto:postgis-users@lists.osgeo.org" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br clear="none"><a shape="rect" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></div><br><br></div> </div> </div> </div></body></html>