Did you even look for the information on postgresql.org?
http://www.postgresql.org/docs/8.2/interactive/sql-createuser.html ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
