On Monday 30 December 2002 19:11, Rick Widmer wrote:
> At 06:20 PM 12/30/02 +0800, Jason Wong wrote:
> >On Monday 30 December 2002 18:13, Boget, Chris wrote:
> > > I'm switching from a MySQL environment to PGSQL and I'm
> > > going through and trying to learn the differences between the
> > > two.
>
> The things that bothered me the most:
>
> o Pg doesn't have DATE_FORMAT(),
pg's date functions are pretty abysmal compared to mysql's.
> or the types SET and ENUM.
These aren't standard and handling these in PHP does require a bit more code.
So you're probably better off using an extra table instead.
> o Changing database structure is harder. With PG, I usually found it
> easier to dump, edit, then reload the database to make changes I did
> in MySQL with ALTER TABLE.
pg's ALTER TABLE doesn't really let you alter much at all which makes
prototyping a pain.
> o The command line program's exit command starts with a \. It took me
> a long time to find that...
Use CTRL-d, it's a very commonly used "exit command" which gets you out of
almost anything -- mysql, psql, ftp, telnet, ssh etc.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Ambiguity:
Telling the truth when you don't mean to.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
