Recording Date,Time and UserId when a record is modified

Поиск
Список
Период
Сортировка
От Sue Hanen
Тема Recording Date,Time and UserId when a record is modified
Дата
Msg-id 01BE6AFC.FD75A100@silver170-92.silverlink.net
обсуждение исходный текст
Список pgsql-sql
Hi

When a record has been modified, I would like a field on that record updated with the date and time.  Do I use
TIMESTAMP? How do I set this up? 

Is is possible to update this same record with the user ID of the person who modified it?  How can I do this?

Thanks much
Sue

В списке pgsql-sql по дате отправления:

Предыдущее
От: Dan Lauterbach
Дата:
Сообщение: How match percent sign in SELECT using LIKE?
Следующее
От: secret
Дата:
Сообщение: Re: [SQL] Re: How to optimize a query... -- Extreme performance difference, same EXPLAIN