To grant privilege on Postgres Database ,

GRANT ALL PRIVILEGES ON databasename TO username ;

================================================== =

Example, GRANT ALL PRIVILEGES ON kinds TO manuel;

================================================== =

Note: There is no user@hostname line in Mysql here.

only

GRANT ALL PRIVILEGES ON databasename TO username

Host access permissions are handled in pg_hba.conf seperately.