Good opportunity missed here too, since a lot of stuff that's a bit of work in other DBs is often less in postgres... if you know the magic words.
This might be handy.
Here's a good write-up on the difference between postgres and MS SQL.
I've been collecting links from this thread for my own personal learning so thought I'd throw in the only one I came here with.
e.g., If you are used to do X this way with MySQL, here's how to do it in Postgres.