Bug report #2887

Large dbf file with export from postgis to shape

Added by tilt - almost 14 years ago. Updated about 5 years ago.

Status:Closed
Priority:Low
Assignee:-
Category:Data Provider
Affected QGIS version:master Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:12947

Description

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.

History

#1 Updated by Giovanni Manghi over 12 years ago

  • Target version changed from Version 1.7.0 to Version 1.7.4

#2 Updated by Paolo Cavallini about 12 years ago

  • Target version changed from Version 1.7.4 to Version 1.8.0
  • Affected QGIS version set to master
  • Crashes QGIS or corrupts data set to No

#3 Updated by Paolo Cavallini over 11 years ago

  • Target version changed from Version 1.8.0 to Version 2.0.0

#4 Updated by Jürgen Fischer almost 10 years ago

  • Target version changed from Version 2.0.0 to Future Release - Lower Priority

#5 Updated by Jürgen Fischer over 9 years ago

  • Assignee deleted (nobody -)
  • Pull Request or Patch supplied set to No

#6 Updated by Giovanni Manghi almost 7 years ago

  • Regression? set to No
  • Easy fix? set to No

#7 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF