Re: PHP & PostgreSQL

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. */