Answers for "postgresql table add user"

how to create a new user in postgresql

CREATE DATABASE yourdbname;CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;

Posted by: Guest on July-03-2020

how to add user to role postgresql

GRANT group_role TO role1, ... ;
REVOKE group_role FROM role1, ... ;

Posted by: Guest on January-27-2021

Code answers related to "postgresql table add user"