Re: how many records - Mailing list pgsql-novice

From Louise Cofield
Subject Re: how many records
Date
Msg-id 000c01c377c0$ce742450$7801a8c0@Louise
Whole thread Raw
In response to how many records  (Bryan Irvine <bryan.irvine@kingcountyjournal.com>)
List 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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Bryan Irvine
Sent: Wednesday, September 10, 2003 9:24 AM
To: pgsql-novice@postgresql.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@postgresql.org


pgsql-novice by date:

Previous
From: "Louise Cofield"
Date:
Subject: Re: phone number list
Next
From: Simon Willison
Date:
Subject: Re: how many records