Postgres Pro
Downloads
Home   >   mailing lists

Re: Table count option - Mailing list pgadmin-support

From Dave Page
Subject Re: Table count option
Date
Msg-id 455B4474.8070805@postgresql.org
Whole thread Raw
In response to Table count option  ("Melvin Davidson" <mdavidson@cctus.com>)
List pgadmin-support
Tree view 
Melvin Davidson wrote:
> 
> Right clicking on a table show the "count" option, which updates the 
> Rows(counted) value in the properties window for the table.
> 
> Is there an equivalent SQL command? ANALYZE/ table_name/  does not work 
> as the equivalent.
> 

SELECT count(*) FROM table;

Regards Dave

pgadmin-support by date:

Previous
From: "Melvin Davidson"
Date:
Subject: Table count option
Next
From: Erwin Brandstetter
Date:
Subject: Re: 1.6RC2 rev: 5636M crashing reproducibly