Home > mailing lists

Re: Timestamp with timezone with Default value - Mailing list pgsql-sql

From	Jasmin Dizdarevic
Subject	Re: Timestamp with timezone with Default value
Date	July 18, 2009 10:25:19
Msg-id	a0eee4d40907180325s2ac61859g71de0746825c28e2@mail.gmail.com Whole thread Raw
In response to	Timestamp with timezone with Default value ("Gianvito Pio" <pio.gianvito@gmail.com>)
List	pgsql-sql

Hi,

i think:

create. ...(

myCol timestamp with timezone default now()

)

i currently have no db to test it - but it should work.

jasmin

2009/7/18 Gianvito Pio <pio.gianvito@gmail.com>

Hi all,
how can I define a column of timestamp with timezone type...with a default value?

Thanks

--
Mit freundlichen Grüßen

Dizdarevic Jasmin
Sonnenbergstr. 3
6714 Nüziders, AUT

jasmin.dizdarevic@gmail.com
+43 664 411 79 29

From: "Gianvito Pio"
Date: 18 July 2009, 08:20:10
Subject: Timestamp with timezone with Default value

From: "Gianvito Pio"
Date: 18 July 2009, 17:09:56
Subject: Table inheritance problem