Accessing database statistics - Mailing list pgsql-novice

From Tony Griffiths(RA)
Subject Accessing database statistics
Date
Msg-id 3CF61469.6070808@cs.man.ac.uk
Whole thread Raw
Responses Re: Accessing database statistics
List pgsql-novice
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


pgsql-novice by date:

Previous
From: "V R"
Date:
Subject: Enabling Auditing in Postgres
Next
From: "Duncan Adams (DNS)"
Date:
Subject: Re: Accessing database statistics