Search Postgresql Archives

Re: Trigger to update table info

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <arvindps@xxxxxxxxxxx> wrote:
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(tablename)

) WITH (oids = false);



where
a) tablename - is the name of table where a record is inserted,updated or deleted
b) updatetime - the time when table was updated (w/o timezone)
c) reccount - records in table
d) size - bytesize of the table

--
for example, if a table called item_master had 1 record and a
 new record is inserted and it's size is 2000 bytes

> postablestatus must have a entry like

item_master        08/12/2013 12:40:00      2     2000
--

I request to know how to write a trigger in PLSQL so that the postablestatus
is updated whenever a record is inserted,updated or deleted in item_master

PLEASE NOTE : a new record must be created if the item_master is not present in postablestatus

thanks in advance
arvind




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux