Hi folks,
There is "reltuples" in pg_class which is approximately equal to select count(*) from relation. i think its updated only on VACUUMING ? (david its not answer to ur question sorry) regds mallah. > I couldn't find anything relating to getting the cardinality of a table. I know a >select will > display number of rows. I was hoping there was a 'cheaper' (less expensive) way >than doing a > full select. > -- > David Bear > College of Public Programs/ASU > > ---------------------------(end of broadcast)--------------------------- TIP 1: >subscribe and > unsubscribe commands go to [EMAIL PROTECTED] ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
