Dennis Gearon <gearond(at)cvc(dot)net> writes:
> So, will this work correctly? ( I am still waiting for SSH
> access to my site to play with Postgres ):
> create table test_timestamp(
> created timestamp DEFAULT CURRENT_TIMESTAMP::timestamptz NOT NULL
> );
I think you want
created timestamptz DEFAULT CURRENT_TIMESTAMP NOT NULL
CURRENT_TIMESTAMP is already timestamptz, you need not cast it. But you
do want the column to be type timestamptz not timestamp.
regards, tom lane