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

[Dylan Beaudette]

On Dec 4, 2005, at 7:24 AM, Kirk Wythers wrote:

> 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?
>
> Thanks,
>
> Kirk
>
>


try this

echo "select count(*) from table" | db.select

this should return the number of rows in table.

Cheers,


--
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341