For some reason, I never tried
$psql --username=testcon testdb
I'm trying to use phpPGAdmin at the same time...I guess I was having a
tough time using both...
thanks Tom for the reply.
On Mon, 2004-10-11 at 16:01, Tom Lane wrote:
> Jonathan Villa <[EMAIL PROTECTED]> writes:
> > $ createdb --ow
Jonathan Villa <[EMAIL PROTECTED]> writes:
> $ createdb --owner=testcon testdb
> but the owner ends up being postgres
I don't think so.
$ createuser testcon
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
$ cre