[postgis-users] corrupt DBF files?

[Vinko Vrsalovic]

Hello,

Has anyone stumped across a DBF file that ArcView, Excel, etc. read
perfectly, but shp2pgsql doesn't?

  From Arcview i see the table fine, from Excel i see some weird
characters, i remove them but shp2pgsql generates only this (if i don't
remove them i get the same behaviour): 

create table vial2 (gid int4 , CODIGO varchar, ROL varchar, NOMBRE varchar, KM_INICIO float8, KM_TERMINO float8, LONGITUD float8, NUMEROPIST float8, TIPO_CARPE varchar, COMUNA varchar, PROVINCIA varchar, REGION varchar, COMENTARIO varchar, FUENTE varchar, ROL_PROPUE varchar);
select AddGeometryColumn('mideplan','vial2','the_geom','-1','GEOMETRY',3);
NULL,'62B240','24','CRUCE LONG. CRUCERO-CALAMA','65564.000000','66162.000000','598.000000','2.000000','ASFALTO','CALAMA','EL LOA','2','','GPS',''


And the data shown is not even from the first row of the file... and no
begin;

The table definition is right.

It's weird that it didn't discovered that it was a polyline, also (well,
MULTILINESTRING in OGC words)

Any hints? 

I'll keep looking into it.

-- 
Vinko Vrsalovic <vinko[|- at -|]cprsig.cl>
http://www.cprsig.cl