[postgis-users] shp2pgsql only giving field names

[John Taber]

Ooops.  After doing a count, all the objects were there.  However if the 
field name listing exceeds the terminal window, it somehow stops there 
with a ":".  Doing a select on just 1 field showed all the records.

John Taber wrote:
> 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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
>