Hi,
i think:
create. ...(
myCol timestamp with timezone default now()
)
the function now() returns a timestamp with timezone (
http://www.postgresql.org/docs/8.4/static/functions-datetime.html)
i currently have no db to test it - but it should work.
jasmin
2009/7/18 Gianvito Pio <pio(dot)gianvito(at)gmail(dot)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(dot)dizdarevic(at)gmail(dot)com
+43 664 411 79 29