<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<div class="udiff-line common" data-fnum="9" data-tnum="9"
style="margin: 0px; padding: 0px;"> Hope this helps.<br>
<br>
shp2pgsql -I -s 4326 -W "latin1" source_shp.shp
schema_xxx.table_xxx |psql -U user -W -d database_name -h
localhost</div>
<div class="udiff-line deletion" data-fnum="10" style="margin:
0px; padding: 0px;">
<div class="gutter" id="Lcaop.mdF10" style="margin: 0px;
padding: 0px; position: absolute; left: 1px; height: 18px;
background-color: rgb(245, 245, 245); border-right-width: 1px;
border-right-style: solid; border-right-color: rgb(204, 204,
204); color: rgb(51, 51, 51); font-family: Arial, sans-serif;
font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
20px; orphans: auto; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;"><a
href="https://bitbucket.org/jgrocha/moradas/commits/c021586584b659afda4f0c2a1e24d4d065b1498f#add-comment"
class="add-line-comment" title="Add a comment to this line"
style="color: rgb(112, 112, 112); text-decoration: none;
-webkit-user-select: none; float: left; width: 16px;
padding: 0px 5px;"><span class="aui-icon aui-icon-small
aui-iconfont-add-comment" style="border: 0px; display:
inline-block; height: 16px; margin: 0px; padding: 0px;
text-align: left; text-indent: -999em; vertical-align:
text-top; width: 16px; line-height: 0; position: relative;
visibility: hidden; background-position: 0px 0px;
background-repeat: no-repeat no-repeat;"></span></a></div>
<br class="Apple-interchange-newline">
</div>
Regards,<br>
Toze<br>
<br>
<br>
<br>
On 16-04-2014 15:35, Rémi Cura wrote:<br>
</div>
<blockquote
cite="mid:CAJvUf_sym__cDOEySs+JHidrw52GWbv6du4dDQDn--atVrs_4A@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Please note that<br>
<br>
</div>
_ogr2ogr is faster (5 times?)<br>
</div>
_ogr2ogr is less reliable (bugs!) <br>
<br>
</div>
Cheers,<br>
Rémi-C<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
2014-04-16 15:12 GMT+02:00 J. Gustavo Rocha <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:jgr@di.uminho.pt"
target="_blank">jgr@di.uminho.pt</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
Oi Rogério,<br>
<br>
I use ogr2ogr, which is more generic than shp2pgsql. You can
choose the schema (active_schema option) and the name of the
table (-nln option).<br>
<br>
Something like:<br>
<br>
ogr2ogr -f "PostgreSQL" PG:"host=<a moz-do-not-send="true"
href="http://xxx.di.uminho.pt" target="_blank">xxx.di.uminho.pt</a>
user=xxx dbname=arhnorte password=yyy active_schema=atlas"
-a_srs EPSG:3763 -nln captacoes Captacoes_SILiAmb.shp<br>
<br>
Regards,<br>
<br>
J. Gustavo<br>
<br>
Em 16-04-2014 13:23, Rogério escreveu:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div class="h5">
Hi,<br>
<br>
How I convert a shp file to sql pointing to a
particular schema and<br>
database?<br>
<br>
As the trivial operation of converting shp to sql is
ok!<br>
<br>
Is possible?<br>
<br>
Thanks!<br>
<br>
--<br>
Rogério A. B. da Silva<br>
Geóg. B. Sc.<br>
<br>
<br>
</div>
</div>
<div class="">
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org"
target="_blank">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users"
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
</div>
</blockquote>
<span class="HOEnZb"><font color="#888888">
<br>
<br>
J. Gustavo<br>
-- <br>
Jorge Gustavo Rocha<br>
Departamento de Informática<br>
Universidade do Minho<br>
4710-057 Braga<br>
Tel: <a moz-do-not-send="true"
href="tel:%2B351%20253604480" value="+351253604480"
target="_blank">+351 253604480</a><br>
Fax: <a moz-do-not-send="true"
href="tel:%2B351%20253604471" value="+351253604471"
target="_blank">+351 253604471</a><br>
Móvel: <a moz-do-not-send="true"
href="tel:%2B351%20910333888" value="+351910333888"
target="_blank">+351 910333888</a><br>
skype: nabocudnosor<br>
<br>
"I would love to change the world, but they won't give
me the source code" -- Unknown Geek</font></span>
<div class="HOEnZb">
<div class="h5"><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org"
target="_blank">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users"
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
António José Silva</div>
</body>
</html>