Re: [GENERAL] Trigger to update table info

2013-08-12 Thread Jayadevan M
Hi, In case you are not keen on getting the latest and really accurate counts/size, you could just refer the views readily available - http://stackoverflow.com/questions/2596670/how-do-you-find-the-row-count-for-all-your-tables-in-postgres You won't get the updatetime, though. Regards, Jayadevan

Re: [GENERAL] Trigger to update table info

2013-08-12 Thread raghu ram
On Mon, Aug 12, 2013 at 12:46 PM, Arvind Singh wrote: > Hello friends, > > I have a table with the following structure > > > Create table postablestatus > > ( > > tablename varchar(30) NOT NULL, > > updatetime timestamp, > > reccount int, > >

[GENERAL] Trigger to update table info

2013-08-12 Thread Arvind Singh
Hello friends, I have a table with the following structure Create table postablestatus ( tablename varchar(30) NOT NULL, updatetime timestamp, reccount int, size int, CONSTRAINT postablestatus_pkey PRIMARY KEY(tablenam