[postgis-users] shp2pgsql only giving field names

John Taber jtaber at johntaber.net
Thu Feb 23 10:03:14 PST 2006


when i do the following on an existing shape file it only inserts 1 row 
and I only get field names returned

shp2pgsql -D myshape.shp mytable mytestdb | psql mytestdb

1 row

psql mytestdb
# select * from mytable;

returns only field names

the myshape.shp file has hundreds of entries that show up okay in qgis. 
  Any ideas if I'm missing something in loading the data ? thks.



More information about the postgis-users mailing list