Re: how many records

From: "Louise Cofield" <lcofield(at)box-works(dot)com>
To: "'Bryan Irvine'" <bryan(dot)irvine(at)kingcountyjournal(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: how many records
Date: 2003-09-10 17:27:27
Message-ID: 000c01c377c0$ce742450$7801a8c0@Louise
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

The only way I have found to do this is with COUNT:
select count(*) from <tablename>;

-Louise

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Bryan Irvine
Sent: Wednesday, September 10, 2003 9:24 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] how many records

Is there an easy way to count how many records there are?

--Bryan

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2003-09-10 17:34:57 Re: phone number list
Previous Message Louise Cofield 2003-09-10 17:26:41 Re: phone number list