Re: PL/PgSQL for counting all rows in all tables.

Robert Treat wrote:

>>
>>Right-click the table object and select 'Count' on the current versions.
>>Previously, iirc it showed the message 'Refresh table to count' in the
>>actual count field, so you did a right-click -> Refresh.
>>
>
>
> Maybe I didn't phrase that quite right. How would a user know that he needs to
> do a real count? For example, if I have a table with est 1 million rows, and
> I load another 1 million rows into it, wont pgadmin show me 1 million rows
> until I run an analyze? Even if I run a manual count, wont it show 1 million
> next time I come into the application, and that time I may not realize that
> the table is off by 1 million rows so I take the estimated count at face
> value.

pgAdmin will either show the true row count from a SELECT COUNT(*), or
"not counted". The last rowcount from vacuum is named "estimated row
count", so it's clearly distinguishable which number is counted and
which is estimated.

Regards,
Andreas