Our site is dedicated to that: http://www.postgresonline.com/

Also check out our new book which came out this month. http://shop.oreilly.com/product/0636920025061.do

Its primary target audience are people coming from other relational databases.

CREATE USER is a standard in many relational databases e.g MySQL, PostgreSQL etc. You really shouldn't be inserting directly into mysql system tables. It's not portable.

PostgreSQL has phppgadmin and pgAdmin which provide a nice GUI experience for role management.

Geography data type came out in 1.5 NOT 2.0. Raster and better 3D support were the big story in 2.0 But stay tuned for 2.1 --> Geography will become MUCH faster: http://blog.opengeo.org/2012/07/12/making-geography-faster/

You don't need to create a custom type to return tuples anymore. (that kind of went out with 8.1). You can use OUT parameters or RETURNS TABLE syntax. RETURNS TABLE is ANSI compliant and supported since 8.3. SQL Server supports RETURNS TABLE as well.