Accessing database statistics

From: "Tony Griffiths(RA)" <griffitt(at)cs(dot)man(dot)ac(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Accessing database statistics
Date: 2002-05-30 12:00:41
Message-ID: 3CF61469.6070808@cs.man.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Duncan Adams (DNS) 2002-05-30 12:06:51 Re: Accessing database statistics
Previous Message V R 2002-05-30 11:16:20 Enabling Auditing in Postgres