Re: Number of rows in a table

From: "paul butler" <paul(at)entropia(dot)co(dot)uk>
To: "Louise Cofield" <lcofield(at)box-works(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Number of rows in a table
Date: 2003-08-25 16:08:05
Message-ID: 3F4A4275.29756.2B4313E8@localhost
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

From: "Louise Cofield" <lcofield(at)box-works(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: [NOVICE] Number of rows in a table
Date sent: Mon, 25 Aug 2003 10:06:28 -0600

SELECT count(ColumnName) FROM TableName;
should do the trick
Paul Butler
> 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.
>
>
>
> Thanks!
>
>
>
>
>
>
>
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tomka Gergely 2003-08-25 16:14:26 Re: Number of rows in a table
Previous Message Louise Cofield 2003-08-25 16:06:28 Number of rows in a table