how to grant access in postgresql code example

Example: postgresql grant all privileges on database

GRANT ALL PRIVILEGES ON dbname TO username;