Setup user/schema in Postgres database?


Let us see how to setup and create the user and schema in postgres database.

We need to download the postgres database latest stable version from the below link:  and install it. 

Using postgres database or by using pgadmin client we can execute the below commands to create user and schema as seen below:-

create user student with password 'student';
grant all on all tables in schema public to student;
grant all on all sequences in schema public to student;
grant all on all functions in schema public to student;

The above commands will create a schema and the and user student successfully as seen below – 

Please make sure to update the pg_hba.conf file under path – under C:\Program Files\PostgreSQL\9.3\data\. Append at the end of the file pg_hba.conf as below:- 

host all all trust

We saw how you can easily setup the database through pgadmin client in few minutes. I hope it helps!