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@innovativesource.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
