[Qgis-user] PostGIS 2 SHP

Ricardo Bayley ricardo.bayley at gmail.com
Tue Oct 26 17:46:36 PDT 2010


Hi Andrea,

How can I set the encoding when exporting from postgres to SHP using the OGR
?


Ricardo

2010/10/23 Ricardo Bayley <ricardo.bayley at gmail.com>

> Thanks Andrea !
>
> Using ogr2ogr does work properly.
>
>
>
> 2010/10/23 Andrea Peri 2007 <aperi2007 at gmail.com>
>
>  Hi fellows,
>>>
>>> I am loading a postgis Layer and then saving it to shapefile. Job gets
>>> done.
>>> BUT, data type character varying, or character, is always set to 255 CHAR
>>> in
>>> the shapefile.
>>> Therefore, my dbf ends up being a huge table. Is this some bug or I am
>>> simply doing something wrong ?
>>>
>>> Any thoughts appreciated
>>>
>>>
>>> Ricardo
>>>
>>
>> The exporting procedure (save as) of qgis do this.
>>
>> But if you use og2ogr (from gdal) to export from postgres to shapefile the
>> string field was exactly the needed.
>> I test with the trunk version of gdal.
>>
>> Regards,
>>
>> Andrea Peri
>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20101026/9ddc1c1a/attachment.html>


More information about the Qgis-user mailing list