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
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,
>
>
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