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 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
[email protected]
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
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor
"I would love to change the world, but they won't give me the source
code" -- Unknown Geek
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
