On Wed, Oct 19, 2005 at 08:23:35AM +0900, Michael Glaesemann wrote:
>
> On Oct 19, 2005, at 2:29 , vittorio wrote:
>
> >Using psql how can I ask postgresql to show the actual number of
> >rows of a
> >table?
>
> For table foo,
>
> select count(*) from foo;
>
> An up-to-date count of the numb
> Using psql how can I ask postgresql to show the actual number of rows of a
> table?
What do you mean by 'actual number of rows'?
Is there a reason you can't just do:
select count(*) from this_table:
--
Mike Nolan
---(end of broadcast)---
T
SELECT COUNT(*) FROM ;
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of vittorio
> Sent: Tuesday, October 18, 2005 10:29 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Number of rows of a table
>
&
On Oct 19, 2005, at 2:29 , vittorio wrote:
Using psql how can I ask postgresql to show the actual number of
rows of a
table?
For table foo,
select count(*) from foo;
An up-to-date count of the number of actual rows is not stored some
place in the database. If an estimate is adequate for
Using psql how can I ask postgresql to show the actual number of rows of a
table?
Ciao
Vittorio
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
