for the first part u might try
select count(*) from <table>;
-----Original Message-----
From: Tony Griffiths(RA) [mailto:griffitt@cs.man.ac.uk]
Sent: Thursday, May 30, 2002 2:01 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Accessing database statistics
Hi,
I need to write a query that returns the number of rows currently stored
in a table. I presume that I issue a query against the system tables,
but don't know which one(s) to do this against. So a couple of questions:
1) With specific reference to my problem, how do I do this?
2) More generally, is there any where that gives detailed descriptions
of the system tables?
Many thanks,
Tony
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org