[postgis-users] shp2pgsql

[Rémi Cura]

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 <jgr at 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 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 at 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
> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140416/c5b03148/attachment.html>