Installation of the Postgres comes with psql, this is a CLI to manage Postgres.
Installation of PostgreSQL 9.3 on Centos 6.4 is as follows;
Open a CLI as root user and retrieve the pgdg repo RPM, then install it. This will allow the Centos to find for software from the pgdg.
rpm -ivh pgdg-centos93-9.3-1.noarch.rpm
Install the client and server.
yum groupinstall "PostgreSQL Database Server 9.3 PGDG"
Initialise database and tables, and start. This creates the default user postgres.
service postgresql-9.3 initdb
bash$ psql -d postgres
If you get the error "psql: could not connect to server: No such file or directory...." Ensure the postgresql server service is running.
As reference, here is summary of the syntax:
CREATE ROLE name [ [WITH] option [ . . . ] ]
where option includes:
SUPERUSER | NOSUPERUSER
LOGIN | NOLOGIN