Quick Links

Community
Contributors
Mailing Lists
IRC
Local User Groups
Events
International Sites

timestamp

From:	"Brian Ward" <brian0(at)verizon(dot)net>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	timestamp
Date:	2002-10-06 14:41:36
Message-ID:	anphrb$24se$1@news.hub.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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?

Responses

Re: timestamp at 2002-10-06 15:38:46 from Brian Ward
Re: timestamp at 2002-10-07 12:25:08 from Larry Rosenman
Re: timestamp at 2002-10-07 12:35:08 from Dan Langille
Re: timestamp at 2002-10-07 12:44:32 from Dan Langille

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Brian Ward	2002-10-06 15:38:46	Re: timestamp
Previous Message	pete	2002-10-06 11:13:41	Re: problem with subqueries