"zagman" <[EMAIL PROTECTED]>
>
> Hi,
>
> 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! I'm also new to postgresql and if
> someone can give me a pointer or two in the right direction I would be
> appreciative.
>
> Thanks,
>
> Dave
>
I think now() or current_timestamp both work.
But I cann't test it now:
create table foo (fno int, ftimestamp timestamp default now());
insert into foo(fno) values (1);
insert into foo(fno) values (2);
select * from foo;
Regards,
William ZHANG
---------------------------(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
