I think I got it but I'm not sure if it's correct. I put the default as CURRENT_TIMESTAMP but I though I had read that was being taken out and only now was supported?
Does anyone know? "Brian Ward" <[EMAIL PROTECTED]> wrote in message anphrb$24se$[EMAIL PROTECTED]">news:anphrb$24se$[EMAIL PROTECTED]... > How do I create a time stamp column in a table that default to the current > time > when a row is inserted? > I tried putting in now() as the default but I have something wrong > with the syntax or something I think > Any one have an example of a table creation script that has a timestamp > column? > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
