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 по дате отправления:

Предыдущее
От: "Peter Galbavy"
Дата:
Сообщение: Re: Timestamp of insertion of the row.
Следующее
От: "Bruno BAGUETTE"
Дата:
Сообщение: How can I recover a 6.5.2 databases in a 7.3.3 database without dump files ?