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]

Reply via email to