Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id DE016475425
	for <pgsql-sql@postgresql.org>; Sun,  6 Oct 2002 10:37:33 -0400 (EDT)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 7785E4753A1
	for <pgsql-sql@postgresql.org>; Sun,  6 Oct 2002 10:37:33 -0400 (EDT)
Received: by news.hub.org (Postfix, from userid 8)
	id 32D46381694; Sun,  6 Oct 2002 10:37:32 -0400 (EDT)
From: "Brian Ward" <brian0@verizon.net>
X-Newsgroups: comp.databases.postgresql.sql
Subject: timestamp
Date: Sun, 6 Oct 2002 10:41:36 -0400
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 9
Message-ID: <anphrb$24se$1@news.hub.org>
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/82
X-Sequence-Number: 9800

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?