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.gianv...@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.dizdare...@gmail.com +43 664 411 79 29