Re: default timestamp in postresql - Mailing list pgsql-php

From Christopher Kings-Lynne
Subject Re: default timestamp in postresql
Date
Msg-id 4108A7B3.2080602@familyhealth.com.au
Whole thread Raw
In response to default timestamp in postresql  (azah azah <izza76@gmail.com>)
Responses Re: default timestamp in postresql
List pgsql-php
> 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


pgsql-php by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: default timestamp in postresql
Next
From: azah azah
Date:
Subject: Re: default timestamp in postresql