[postgis-users] Integer (PostGIS) fields become real in QGIS!

[Vito Meuli]

Hi!
I'm using shapefile exported from PostGIS using pgsql2shp.
But QGIS takes the integer fields as they were real!

I've tryed different version of PostGIS, and something changed: integer=int4 
become a 16 digit precision in a shapefile exported using PostGIS 1.0.6, and 
a 11 digit precision using PostGIS 1.3.3...
What a pity, it seems that an integer remains an integer if it is 10 digit 
precision!

It's not better if I use smallint instead of int4: pgsql2shp acts the same 
way.

If I export shapefiles from PostGIS using QGIS directly, all goes well and the 
int4 remain integer.

Is there some other way to extract shapefile using a shell (Linux) script and 
letting them have integer fields of 10 digit precision?

Any help would be appreciated.
Bye
Vito
-- 
Ing. Vito Meuli

Tecnologie Avanzate S.r.l.
via B. Croce, 49
70015 Noci (BA)
tel. +39 080 4979652
fax  +39 080 4979263

email: v.meuli at tecnologieavanzate.it
http://www.tecnologieavanzate.it