This is a discussion on Re: Table count option within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> Melvin Davidson wrote: > Dave, > > Yes SELECT count(*) FROM table; will give me a count of rows ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Melvin Davidson wrote: > Dave, > > Yes SELECT count(*) FROM table; will give me a count of rows > but it does _not_ update the "Rows(counted) value in the properties > window" > > So what is the equivalent function to update the "Rows(counted) value in > the properties window"??? Right-click -> Count. The value shown is retrieved on the fly using SELECT count(*), but only if the estimated value is lower than the threshold set under Tools->Options (unless you explicitly select Count from the menu). Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |