On Mon, 2006-10-16 at 14:56 -0400, Harpreet Dhaliwal wrote: > Hi, > I have a timestamp field in my table and want to set a default value > of current date/time for it. > What should i enter as its default value? is there any function like > now() in postgres? > > Thanks, > ~Harpreet
test=# select now(); now ------------------------------- 2006-10-16 15:03:13.174644-04 (1 row) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly