Re: How do I make a timestamp column default to current time - Mailing list pgsql-general

From Tom Lane
Subject Re: How do I make a timestamp column default to current time
Date
Msg-id 17573.1142527298@sss.pgh.pa.us
Whole thread Raw
In response to How do I make a timestamp column default to current time  ("zagman" <daveh@allheller.net>)
Responses Re: How do I make a timestamp column default to current time  ("John D. Burger" <john@mitre.org>)
List pgsql-general
"zagman" <daveh@allheller.net> 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

pgsql-general by date:

Previous
From: Louis Gonzales
Date:
Subject: Re: PostgreSQL scalability concerns
Next
From: Scott Ribe
Date:
Subject: Error I don't understand, losing synch with server