PostgreSQL - Create Role for a Database Link to heading
Problem Link to heading
I want to create a role that has all permissions on a database (owner of such database) so the application can do whatever it needs within the db.
Solution Link to heading
First PostgreSQL - Create UTF-8 Database.
CREATE ROLE "role_name" WITH LOGIN PASSWORD '<password>';
ALTER DATABASE "db_name" OWNER TO "role_name";