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

From azah azah
Subject Re: default timestamp in postresql
Date
Msg-id 235b1a2804072900586733ae40@mail.gmail.com
Whole thread Raw
In response to Re: default timestamp in postresql  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-php
thanks all, it solve now.

On Thu, 29 Jul 2004 15:30:59 +0800, Christopher Kings-Lynne
<chriskl@familyhealth.com.au> wrote:
> > 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: Christopher Kings-Lynne
Date:
Subject: Re: default timestamp in postresql
Next
From: Daniel Struck
Date:
Subject: Re: [ADMIN] Secure DB Systems - How to