Re: Timestamp of insertion of the row.

Поиск
Список
Период
Сортировка
От Mendola Gaetano
Тема Re: Timestamp of insertion of the row.
Дата
Msg-id 004801c33000$0606d470$152aa8c0@GMENDOLA2
обсуждение исходный текст
Ответ на Timestamp of insertion of the row.  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
Список pgsql-admin
"Anagha Joshi" <ajoshi@nulinkinc.com> wrote:
> Hi,
> Is there any way to know data & time when the row is inserted into a
> table?


You should define a supplementary field with default value "now()"
this field will contain the transaction start time, if you want have the
real time (if you insert a milion of row inside the same transaction
using now() you'll have the same timestamp ) you should use instead:
"timeofday()".

Regards
Gaetano Mendola


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