Transferring concepts - users/groups/permissions of db objects from mysql to postgresql
Granting permissions to users works exactly the same way in PostgreSQL.  There are some differences in the advanced features, but what you wrote above works fine.