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

Quantum GIS qgis at qgis.org
Thu Jul 15 06:24:14 EDT 2010


#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


More information about the QGIS-trac mailing list