postgresql_user: fix docstrings

Change documentation of "state" param to refer to user (role) state instead of
database state.

Change 2 function docstrings to reflect the code