Unix Technical Forum

Re: Table count option

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:39 PM
Dave Page
 
Posts: n/a
Default Re: Table count option

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:19 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com