What is the syntax for setting a default date in PostgreSQL?

From: Frank Church <pgsql(at)adontendev(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: What is the syntax for setting a default date in PostgreSQL?
Date: 2006-02-20 10:59:28
Message-ID: 1140433168.43f9a1107c27b@webmail.adontendev.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


This issue always stumps me. I need to set the default date for a column in
postgres. A value for today, today + x days, now (timestamp), now + x amount of
days.

I never seem to be able to locate it in the documentation or online. Can anyone
post it here once and for all for posterity?

I will be much obliged :)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2006-02-20 11:13:05 Re: What is the syntax for setting a default date in PostgreSQL?
Previous Message Andreas Seltenreich 2006-02-20 10:45:24 Re: simple explain output.