I've been working with PHP and mySQL for the ... job listings talk about postgreSQL and msSQL and such. I've heard of such things, but I don't really know what differences there are.< ...

I have heard a lot of people recommend postgresql over mysql because ... I have heard that mysql cannot store procedures and triggers, and also cannot use primary or foreign key associations.