> The PostgreSQL website has excellent documentation (second only to
> php.net). If you already know MySQL, then you're 2/3 of the way there.
> You just need to get used to the quirks of PostgreSQL.
A more accurate statement would be "You just need to learn where the
quirks you've picked up by using MySQL are." You should be able to jump
right in and start using Postgres. But you'll probably need the use the
manual at first. The good news is that once you learn Postgres, your
skills will be a lot more transferable to other databases.
This article is a bit dated but still good.
http://www.xach.com/aolserver/mysql-to-postgresql.html
Scott Bailey