[QGIS-trac] [Quantum GIS] #2887: Large dbf file with export from postgis to shape

[Quantum GIS]

#2887: Large dbf file with export from postgis to shape
------------------------------------+---------------------------------------
   Reporter:  tilt                  |              Owner:  nobody       
       Type:  bug                   |             Status:  new          
   Priority:  minor: annoyance      |          Milestone:  Version 1.5.0
  Component:  Build/Install         |            Version:  1.4.0        
   Keywords:  postgis shape export  |   Platform_version:  XP           
   Platform:  Windows               |           Must_fix:  No           
Status_info:  0                     |  
------------------------------------+---------------------------------------
 Reproduce:
 1. Open postgis table in qgis.
 2. Save as shapefile

 Same postgis table exported via pgsql2shp gives 4x smaller dbf file.
 Does not happen with every dataset. It seems that the varchar fields are
 exported as textfield with length 255. Also some numeric fields are
 exported as text with length 21.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2887>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats