Re: Schema authorization after create database. - Mailing list pgsql-admin

Ian FREISLICH <if@hetzner.co.za> writes:
> I ran into this little astonishment yesterday on 7.4.8.  When I
> create a database connected as the super user using:

> CREATE DATABASE foo OWNER = foo;

> The database is indeed owned by user foo, but the automatically
> created public schema is is owned by the database super user.  Should
> this schema not be created as owned by the database owner specified
> in the CREATE DATABASE command?

That's the way it's supposed to work.  CREATE DATABASE does not change
anything inside the copied database.

            regards, tom lane