Re: NewB question wrt Create Database - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: NewB question wrt Create Database
Date
Msg-id 47A65128.1020400@lelarge.info
Whole thread Raw
In response to NewB question wrt Create Database  (Josh <josh@globalherald.net>)
List pgadmin-support
Hi,

Josh wrote:
> I have a question about the behavior of PGAdmin (or perhaps this is PG) 
> in creating databases.
> 
> If I create a DB while logged in as postgres, and indicate the database 
> owner is another login role, then PG creates the database with that 
> login role being the owner but everything within the db is owned by 
> Postgres. So, for example, I can't go start creating tables and such as 
> the login role because that role does not own the public schema.
> 
> Why does it behave in this way?
> 

It doesn't behave like this for me. Which PostgreSQL release do you use 
? did you try the same thing with psql or phppgadmin ?


-- 
Guillaume. http://www.postgresqlfr.org http://dalibo.com


pgadmin-support by date:

Previous
From: Josh
Date:
Subject: NewB question wrt Create Database
Next
From: Steve Logue
Date:
Subject: Help Please