"Anagha Joshi" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
