| From: | Dave Page <dpage(at)postgresql(dot)org> |
|---|---|
| To: | Melvin Davidson <mdavidson(at)cctus(dot)com>, "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Table count option |
| Date: | 2006-11-15 21:43:56 |
| Message-ID: | 455B8A1C.7070204@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2006-11-15 21:56:01 | Re: Table count option |
| Previous Message | Erwin Brandstetter | 2006-11-15 17:53:40 | Re: Test results for 1.6RC2 rev: 5636M |