| From: | John Taylor <postgres(at)jtresponse(dot)co(dot)uk> |
|---|---|
| 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:17:34 |
| Message-ID: | 02053013173401.02083@splash.hq.jtresponse.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thursday 30 May 2002 13:00, Tony Griffiths(RA) wrote:
> 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?
select count(*) from mytable;
> 2) More generally, is there any where that gives detailed descriptions
> of the system tables?
I always take the view that they are for use by the system, and not for me.
I haven't needed system tables yet.
JohnT
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Duncan Adams (DNS) | 2002-05-30 12:36:51 | Re: Accessing database statistics |
| Previous Message | Tony Griffiths(RA) | 2002-05-30 12:10:09 | Re: Accessing database statistics |