Re: mysql to pgsql
| From: | Jeff MacDonald | Date: | Mon, 05 Feb 2001 13:27:05 +0000 |
| Subject: | Re: mysql to pgsql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6395@lists.php.net to get a copy of this message | ||
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" <gamr@gattcomp.com.au>
> To: <php-db@lists.php.net>
> 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: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
> >
>
>
>
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
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