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 <[email protected]>:

> 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
>
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Reply via email to