Re: the behaviour of timestamp on postgres. - Mailing list pgsql-general

From Doug McNaught
Subject Re: the behaviour of timestamp on postgres.
Date
Msg-id 87657pepxb.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to the behaviour of timestamp on postgres.  (Prabu Subroto <prabu_subroto@yahoo.com>)
Responses Re: the behaviour of timestamp on postgres.
List pgsql-general
Prabu Subroto <prabu_subroto@yahoo.com> writes:

> How can I make the postgres complete the value of the
> timestamp field automatically?

Add a DEFAULT NOW() clause to the column definition.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Nick Barr
Date:
Subject: POSIX RE starting with a (
Next
From: Nick Barr
Date:
Subject: Re: POSIX RE starting with a (