From: | Jonathan Villa <jvilla(at)innovativesource(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: created databases as other users... |
Date: | 2004-10-11 21:10:19 |
Message-ID: | 1097529019.2833.98.camel@jonathan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <jvilla(at)innovativesource(dot)net> 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
> $ createdb --owner=testcon testdb
> CREATE DATABASE
> $ psql -l
> List of databases
> Name | Owner | Encoding
> ------------+---------+-----------
> pltest | tgl | SQL_ASCII
> regression | tgl | SQL_ASCII
> template0 | tgl | SQL_ASCII
> template1 | tgl | SQL_ASCII
> testdb | testcon | SQL_ASCII
> (5 rows)
>
> $
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-10-12 00:53:30 | Changes to CVS requires Fresh Checkout |
Previous Message | Tom Lane | 2004-10-11 21:01:04 | Re: created databases as other users... |