Answers for "set role postgres"

postgresql create role

CREATE ROLE role_name;

Posted by: Guest on September-08-2021

change role postgres

# make 'dave' superuser and allow him to create databases
ALTER ROLE dave WITH SUPERUSER;
ALTER ROLE dave WITH CREATEDB;

Posted by: Guest on July-14-2020

postgresql create role

CREATE ROLE role_name with NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS;

Posted by: Guest on September-08-2021

postgresql change user role grant

=# ALTER USER role_specification WITH OPTION1 OPTION2 OPTION3;

Posted by: Guest on July-22-2020

Code answers related to "set role postgres"