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