create table foobar (todaysdate datetime default now());
jeff
On Sun, 4 Feb 2001, phobo wrote:
> Never used pgsql; but try DEFAULT NOW() NOT NULL ??
>
> Siggy
>
> ----- Original Message -----
> From: "Cameron" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, February 04, 2001 5:18 AM
> Subject: [PHP-DB] mysql to pgsql
>
>
> > can someone help me convert this to do the same in pgsql? below is the
> > current structure for one item in my database, i need pgsql to be able
> > to produce the same results as what mysql is currently. suggestions?
> >
> > i want the database to return the current date when "nothing" is
> > inserted into that field
> >
> > contact_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL
> >
> >
> > Cameron
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
[EMAIL PROTECTED] | [EMAIL PROTECTED]
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick : bignose
PGP Public Key : http://bignose.hub.org/public.txt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
