> Hi list,
>
> I created user for my pgsql DBMS.
> When I created them, I was asked if i wanted to create a db for them.
> I answered no.
>
> But now, I want to create a db owned by one of them and not by postgres
> user. But I cannot find how to do it...
> the createdb command seems not to be able to create dbs for a user
> different of postgres user.
>
> I don't want to create a db owned by postgres and then grant rights to
> the users in this db. I want to have dbs owned by this users.
>
> How can I do ?
>
login as the user you want as owner, and issue the createdb command.
You'll need to have database creation permissions for that user.
Cheers
{.n+j)kyZX-aj(칻 &jay+-
