"zagman" <daveh@xxxxxxxxxxxxx> writes: > I'm setting up a simple timecard program and I need a column that > defaults to the current time when a new row is inserted. How can I do > this I tried setting the default to 'now' but all that does is put the > time I created the table in each row! The default has to be a function call, not a literal constant, to work the way you want. Try mycol timestamp default now() or mycol timestamp default current_timestamp (the latter is actually a function call, even though the SQL standard says it has to be spelled without any parentheses) regards, tom lane
