running postgres

From: Kusuma Pabba <kusumap(at)ncoretech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: running postgres
Date: 2009-02-05 06:35:31
Message-ID: 498A88B3.3050803@ncoretech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Schwaighofer Clemens 2009-02-05 07:21:05 Re: running postgres
Previous Message justin 2009-02-05 05:02:07 Re: debugging plpgsql functions