"Martin Hurst" <martinh@ix.netcom.com> writes:
> Is there a way to get the row count of a user table without doing the?
> select count(*) from <table>
If this were an easy problem, count() would do it for you ;-)
If you're willing to settle for an approximate answer,
pg_class.reltuples might do. It's the row count as of the last VACUUM.
regards, tom lane