default date

From: "Krasnow, Greg" <gak(at)hnc(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: default date
Date: 1998-08-03 18:43:26
Message-ID: C162BB3549A5CF118D7400805FD412240177C518@pchnc.hnc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How can I create a table which has a date field and have the date field
default to the system time when the record is inserted... like Oracle's DATE
DEFAULT SYSDATE? Thanks.

- Greg

Greg Krasnow
HNC Software Inc.
Financial Solutions Group
Senior Software Engineer
Email: gak(at)hnc(dot)com
Direct Phone: 619.799.8341
Fax: 619.799.8036

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John E. Garrott 1998-08-03 19:12:13 Re: [GENERAL] psql problem
Previous Message Robert Nosko 1998-08-03 16:20:12 lo_import() problem