Re: timestamps - Mailing list pgsql-general

From Tom Allison
Subject Re: timestamps
Date
Msg-id 40B3F35F.5060006@tacocat.net
Whole thread Raw
In response to Re: timestamps  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
Doug McNaught wrote:
> Tom Allison <tallison@tacocat.net> writes:
>
>
>>How would I specify a field that's to be updated to current_time
>>everytime the row is created/altered?
>
>
> Create a trigger.  There are some good examples in the PL/pgSQL docs.
>
>
>>Is there some way to put this 'update' property into the table instead
>>of running some query to do it?
>
>
> Triggers are the way to go in Postgres.
>
> -Doug
>

Thanks for the pointer.  That should be enough.


pgsql-general by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: timestamps
Next
From: Wei Shi
Date:
Subject: Re: About table schema