Re: Timestamp with timezone with Default value

On 2009-07-18, Gianvito Pio <pio(dot)gianvito(at)gmail(dot)com> wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0017_01CA0791.49E30EB0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi all,
> how can I define a column of timestamp with timezone type...with a =
> default value?

Same as any other column with a default value.

If you're inserting NULL into the column the NULL will override the
default. Postgres does what you tell it.

If you want the default value use the keyword DEFAULT (in for the
value in that column) or don't mention that column. The DEFAULT
keyword also works with UPDATE.