Re: Number of rows in a table - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Number of rows in a table
Date
Msg-id 1061828603.503.7.camel@billy
Whole thread Raw
In response to Re: Number of rows in a table  (Tomka Gergely <tomka@zeus.gau.hu>)
List pgsql-novice
Am Mo, 2003-08-25 um 18.14 schrieb Tomka Gergely:
> 2003-08-25 ragyogó napján Louise Cofield ezt üzente:
>
> > I haven't been able to figure out how to determine the number of
> > populated rows in a table - such as "select max(rownum)" in Oracle.
>
> select count(*) from usw.; ?

Keep i mind Louise, that this is an aggregate function, i.e. all other
columns you want to get in the same query must be GROUPed or used in an
aggregate function, too.

bye
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: "Gaitor, Jim"
Date:
Subject: Unsubscribe
Next
From: "Patrick Hatcher"
Date:
Subject: Way to tell what SQL is currently running?