table row count - Mailing list pgsql-general

From Martin Hurst
Subject table row count
Date
Msg-id 007c01c2cff9$5bf9d060$0201a8c0@newpc
Whole thread Raw
Responses Re: table row count
Re: table row count
List 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







pgsql-general by date:

Previous
From: Dustin Sallings
Date:
Subject: Re: How to do unique users
Next
From: Bruno Wolff III
Date:
Subject: Re: table row count