PostgreSQL - Create Role for a Database

PostgreSQL - Create Role for a Database#

Problem#

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#

First PostgreSQL - Create UTF-8 Database.

CREATE ROLE "role_name" WITH LOGIN PASSWORD '<password>';
ALTER DATABASE "db_name" OWNER TO "role_name";

Related#

• PostgreSQL - Create UTF-8 Database