DB> Folks,

DB> Is there a catalog table or location where I can go to find data counts for
DB> tables?

DB> It would be nice if I could do a query which returned something like:

DB> table_name #Rows
DB> cust 1000
DB> order 5000
DB> order_detail 9500

DB> without having to have the overhead of querying each table in turn.

DB> If there is such a source then is it accurate as of now or last vacuum or
DB> ???

The pg_class table has a reltuples field but only the vacuum process updates it.

DAQ


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster