Re: Number of rows of a table

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: vdemart1(at)tin(dot)it (vittorio)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Number of rows of a table
Date: 2005-10-19 02:51:15
Message-ID: 200510190251.j9J2pGQa001521@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-10-19 02:55:22 Re: [GENERAL] Oracle buys Innobase
Previous Message Johan Wehtje 2005-10-19 02:47:33 Re: ANN: Rekall V2.4.0