Answers for "postgres create role if not exists"

psql: error: FATAL: role "postgres" does not exist

createuser -U postgres -s YOURUSERNAME
createdb YOURUSERNAME

Posted by: Guest on January-09-2021

role "postgres" does not exist

template1=# CREATE USER username WITH PASSWORD 'user_password';
template1=# GRANT ALL PRIVILEGES ON DATABASE "user_database" to username;

Posted by: Guest on June-04-2021

postgresql create user roles

CREATE ROLE admin WITH CREATEDB CREATEROLE;

Posted by: Guest on July-22-2020

Code answers related to "postgres create role if not exists"