Обсуждение: Resources for learning PostgreSQL
Hi, I've used mysql for sometime now, and I'd like to broaden my db knowledge/experience to include postgresql. Can anyone recommend any books or other resources that could help me along? Thanks. -Dan -- View this message in context: http://www.nabble.com/Resources-for-learning-PostgreSQL-tp25530840p25530840.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Tue, Sep 22, 2009 at 10:43:09AM -0700, dan06 wrote: > > Hi, > > I've used mysql for sometime now, and I'd like to broaden my db > knowledge/experience to include postgresql. Can anyone recommend any books > or other resources that could help me along? Thanks. 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. For books, I have two: Beginning Databases with PostgreSQL 2/e by Matthew & Stones PostgreSQL 2/e by Douglas & Douglas These are better than the original PostgreSQL: Introduction and Concepts by Momjian (sorry, Bruce). That book struck me as mostly a transcription of the existing documentation at the time. It was very helpful when there were no other PostgreSQL books out there. But you may not even need the books, if you peruse the website. Paul -- Paul M. Foster
> 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