<div>
i think &quot;last record insert/update time&quot; is not clear enough.<br />
<br />
What i mean is - for any record in the database i should be able to find out when was the record last updated.
</div>


i think "last record insert/update time" is not clear enough.

What i mean is - for any record in the database i should be able to find out when was the record last updated.

<div>
You have to store this information per row... again, this is not implemented by default, so you need to implement this on your own...<br />
CHeers
</div>


You have to store this information per row... again, this is not implemented by default, so you need to implement this on your own...
CHeers

<div>
The accepted method is to use a trigger on UPDATE to put an entry in a LOG table. Then a simple SQL statement to find the entry.<br />
<br />
Regards<br />

</div>


The accepted method is to use a trigger on UPDATE to put an entry in a LOG table. Then a simple SQL statement to find the entry.

Regards


<div>
So u mean i would have to put a trigger on update on all my &nbsp;tables in the database ?
</div>


So u mean i would have to put a trigger on update on all my  tables in the database ?

<div>
Thanks Angel !!! <br />
Oh the strange ways of Databases. !
</div>


Thanks Angel !!!
Oh the strange ways of Databases. !

<div>
if PostgreSQL has a facility do let me know. I don;t think it would have !
</div>


if PostgreSQL has a facility do let me know. I don;t think it would have !

<div>
<div class="content wysiwyg-content">
Is there a way to get the last record insert/update time in RDBMS. I am specifically looking if PostgreSQL database has a way to provide me this.<br />
<br />
I know i can code for this in my every UPDATE/INSERT statement. But if i database can provide me this for every record without me doing any coding that would be great.<br />
<br />
Help !!
</div>
</div>


Is there a way to get the last record insert/update time in RDBMS. I am specifically looking if PostgreSQL database has a way to provide me this.

I know i can code for this in my every UPDATE/INSERT statement. But if i database can provide me this for every record without me doing any coding that would be great.

Help !!

Record Insertion/Update time

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.