Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice... - Mailing list pgsql-general

Dennis Gearon <gearond@cvc.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