Re: Table count option

From: Dave Page <dpage(at)postgresql(dot)org>
To: Melvin Davidson <mdavidson(at)cctus(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Table count option
Date: 2006-11-15 16:46:44
Message-ID: 455B4474.8070805@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Erwin Brandstetter 2006-11-15 17:04:55 Re: 1.6RC2 rev: 5636M crashing reproducibly
Previous Message Melvin Davidson 2006-11-15 16:25:43 Table count option