table row count

From: "Martin Hurst" <martinh(at)ix(dot)netcom(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: table row count
Date: 2003-02-09 05:08:59
Message-ID: 007c01c2cff9$5bf9d060$0201a8c0@newpc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to get the row count of a user table without doing the?

select count(*) from <table>

which can take some time and even do a table scan if the table has millions
of rows in it.

Are there any system tables or views that hold this value for any given user
table?

-Martin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-09 06:11:45 Re: table row count
Previous Message Dustin Sallings 2003-02-09 03:56:08 Re: How to do unique users