On Sat, Sep 25, 2004 at 07:20:23PM -0400, Tom Allison wrote: > > Any idea how to set up a timestamp=now on every insert/update ?
when you create your table, use:
create table mytable (
id serial primary key,
updated timestamp default(now()),
mydata int4
);
Joe
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
