[postgis-users] shp2pgsql DBF-Column type boolen wrong

[Düster Horst]

I try to convert a shapefile with one column of type boolean via shp2pgsql.
In the resulting pgsql table this column appears as type varchar instead of
type boolean. I found out the following facts:

- Coversion shp->pgsql:  
	shp2pgsql -d¦-c ...	boolean is changed to varchar
	shp2pgsql -a		boolean is correct when in table definition
the field is defined as boolean

- Conversion pgsql->shp		works correct, table boolean appears as shp
boolean


My system:

Windows
  shp2pgsql 1.88.2.7 
  pgsql2shp 1.74.2.4

Linux
 Postgresql 8.1
 Postgis 1.0.4

I would be grateful for any hint.

Regards

Dr. Horst Düster 
GIS-Koordinator, Stv. Amtsvorsteher

Kanton Solothurn 
Amt für Geoinformation
Abteilung SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn 

Tel.: ++41 (0)32 627 25 32 
Fax: ++41 (0)32 627 22 14

horst.duester at bd.so.ch 
www.sogis.so.ch