Обсуждение: system variable for update

Поиск
Список
Период
Сортировка

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



Re: system variable for update

От
"A.Bhuvaneswaran"
Дата:
> 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