gistfile1.txt

[10/19/15, 3:47:56 PM] Juan E. Maya: create role  slftestdb login password '^1mnuj7s';
[10/19/15, 3:48:11 PM] Juan E. Maya: create schema ims authorization slftestdb; 
create schema pgcontrib;
grant all on schema ims to slftestdb; 
grant all on schema pgcontrib to slftestdb; 
alter user  slftestdb set search_path = ims, pgcontrib; 
SET search_path TO ims, pgcontrib,public; 
revoke create on schema public from public;
commit;