system variable for update

[Ashok Chauhan]

hello

in postgresql there is any system variable for update

Means if i update a record so any system variable store the
timestamp(update time) of that updated record.
Thankyou
Ashok



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[A.Bhuvaneswaran]

Post by Ashok Chauhan
in postgresql there is any system variable for update

No such built-in feature is available. But, we can write a before
trigger on update event to set the modified time.

regards,
bhuvaneswaran



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings