Objectives: using command line: pgAdminII.exe creating role @ command line Modify the role using pgAdminIII.exe
Objectives:
Now using pgsql : password :postgre_manas9
CREATE ROLE manas237 LOGIN NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
Note the changes in the
CREATE ROLE manas237 LOGIN ENCRYPTED PASSWORD 'md5b14afbf9d130ffaf51501a1cd619ec3e' NOSUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION VALID UNTIL '1969-12-31 00:00:00';