[GRASSLIST:9318] Re: number of rows in a table?

Hamish hamish_nospam at yahoo.com
Mon Dec 5 20:21:53 EST 2005


> >> I need to find the number of rows in a table. I have some vector  
> >> files that crash qgis, yet grass opens them fine. Looking at the  
> >> dbf files, I suspect the the issue is the file size (20 - 30 MB).  
> >> I wanted to check the number of rows and I've been looking through 
> >>
> >> the db commands, unfortunately, so far all I have come across is  
> >> using using db.describe to get the number of columns. Any  
> >> suggestions?

as suggested, with dbview:

dbview -bt file.dbf | wc -l

perhaps with a grep thrown in and redirection to a > file.dat for subset
testing.



Hamish




More information about the grass-user mailing list