Re: default timestamp in postresql

> Previously in mysql table field as below , will be add automatic in
> database when execute insert statement.
>
>              = submittime timestamp NOT NULL
>
> But in postresql the timestamp cannot insert automatic when execute
> insert statement.
> How can I solve this problem instead of change the php code?

Make it:

submittime timestamp not null default current_timestamp

Chris