running postgres - Mailing list pgsql-general

From Kusuma Pabba
Subject running postgres
Date
Msg-id 498A88B3.3050803@ncoretech.com
Whole thread Raw
Responses Re: running postgres  (Schwaighofer Clemens <clemens.schwaighofer@tequila.jp>)
Re: running postgres  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
may this be a silly doubts but , i am new to postgres, please answer to
these::

 /usr/local/pgsql/bin/psql test
test=#


 sudo su postgres -c psql template1
template=#


what is the difference between the above two and,
why is the path different in both cases
which should i use now


how can i create a user  in test or template
when i give create user
it is asking for create role , how should i create role?



Thanks & Regards
 kusuma.p

pgsql-general by date:

Previous
From: justin
Date:
Subject: Re: debugging plpgsql functions
Next
From: Schwaighofer Clemens
Date:
Subject: Re: running postgres