On Monday 25 February 2008 18:21, Aaron Bono wrote: > On Mon, Feb 25, 2008 at 7:21 PM, David Bear <david.bear@xxxxxxx> wrote: > > I've been reading about triggers on insert and found the page at > > http://www.postgresql.org/docs/8.1/interactive/triggers.html with some > > sample > > code in the comments. > > > > I'm thinking what I want can't really be this involved. > > > > I want to have a table with a timestamp field that automatically gets the > > value of now() on insert. The timestamp will never be updated. I assume I > > need to create a trigger to do this. If there is an easier way, please > > advise. > > > > Otherwise, is there any sample code that would should be how to do this? > > The > > sample on the page above looks like > > overkill.<http://www.postgresql.org/docs/faq> > > In your create table statement: > > "create_dt" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL Thanks. I knew it must be easier. This is exactly what I want. -- David Bear College of Public Programs/ASU 411 N Central, Phoenix, AZ 85004 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
