Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E0F69475A71 for ; Sun, 6 Oct 2002 11:34:43 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 7B7C5475458 for ; Sun, 6 Oct 2002 11:34:42 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 087F5381694; Sun, 6 Oct 2002 11:34:40 -0400 (EDT) From: "Brian Ward" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: timestamp Date: Sun, 6 Oct 2002 11:38:46 -0400 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 19 Message-ID: References: X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/84 X-Sequence-Number: 9802 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" wrote in message news:anphrb$24se$1@news.hub.org... > 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? > >