From: | "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za> |
---|---|
To: | "'Tony Griffiths(RA)'" <griffitt(at)cs(dot)man(dot)ac(dot)uk>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Accessing database statistics |
Date: | 2002-05-30 12:06:51 |
Message-ID: | 7DD34E6DF5CD1B4283DDAB96A855DCED2F33B5@vodabemail1.vodacom.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
for the first part u might try
select count(*) from <table>;
-----Original Message-----
From: Tony Griffiths(RA) [mailto:griffitt(at)cs(dot)man(dot)ac(dot)uk]
Sent: Thursday, May 30, 2002 2:01 PM
To: pgsql-novice(at)postgresql(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Griffiths(RA) | 2002-05-30 12:10:09 | Re: Accessing database statistics |
Previous Message | Tony Griffiths(RA) | 2002-05-30 12:00:41 | Accessing database statistics |