Re: how many records

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