Thread: system variable for update

system variable for update

From
Ashok Chauhan
Date:
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



Re: system variable for update

From
"A.Bhuvaneswaran"
Date:
> 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