Hope this helps.
shp2pgsql -I -s 4326 -W "latin1" source_shp.shp schema_xxx.table_xxx
|psql -U user -W -d database_name -h localhost
<https://bitbucket.org/jgrocha/moradas/commits/c021586584b659afda4f0c2a1e24d4d065b1498f#add-comment>
Regards,
Toze
On 16-04-2014 15:35, Rémi Cura wrote:
Please note that
_ogr2ogr is faster (5 times?)
_ogr2ogr is less reliable (bugs!)
Cheers,
Rémi-C
2014-04-16 15:12 GMT+02:00 J. Gustavo Rocha <j...@di.uminho.pt
<mailto:j...@di.uminho.pt>>:
Oi Rogério,
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).
Something like:
ogr2ogr -f "PostgreSQL" PG:"host=xxx.di.uminho.pt
<http://xxx.di.uminho.pt> user=xxx dbname=arhnorte password=yyy
active_schema=atlas" -a_srs EPSG:3763 -nln captacoes
Captacoes_SILiAmb.shp
Regards,
J. Gustavo
Em 16-04-2014 13:23, Rogério escreveu:
Hi,
How I convert a shp file to sql pointing to a particular
schema and
database?
As the trivial operation of converting shp to sql is ok!
Is possible?
Thanks!
--
Rogério A. B. da Silva
Geóg. B. Sc.
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
<mailto:postgis-users@lists.osgeo.org>
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480 <tel:%2B351%20253604480>
Fax: +351 253604471 <tel:%2B351%20253604471>
Móvel: +351 910333888 <tel:%2B351%20910333888>
skype: nabocudnosor
"I would love to change the world, but they won't give me the
source code" -- Unknown Geek
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
--
António José Silva
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users