The following are a set of simple commands to configure your PostgreSQL database. These commands are after you have successfully installed the database application.
Creating a database
To create a database you can use the following. Please note the semicolon at the end of each command. CREATE DATABASE test;
Creating a User
To Create a user, you can use the following command. In this case a user named "test" with password "test" will be created. Please note that the password must be enclosed in single quote and don't forget about the semicolon. CREATE USER test WITH PASSWORD 'test';
Granting Permissions
A user might need access rights to a given database. The GRANT command can be used to give privileges to a user. In the following example the user test will be given all rights to database test. GRANT ALL ON DATABASE test TO test;
Changing the user roles
The ALTER command is used to give a user special a roles such as Superuser. ALTER USER test WITH Superuser;
Some useful display commands
To get a listing of all the commands - Help: \? To list tables, views, and sequences: \d[S+] Similarly, to describe table, view, sequence, or index: \d[S+]
To show all users (roles) and attributes: \du To get a listing of all database: \l To connect to databases, users, hosts or ports: \c example: \c test connects to database test created above