Обсуждение: create database with owner

Hi,

using postgres ( super user) , I create a database for user1 (normal role)

1. create database db1 owner user1;
2. \l

postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access
privileges
-----------+----------+----------+-------------+-------------+-----------------------
 db1       | user1    | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
postgres=CTc/postgres
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
postgres=CTc/postgres
(4 rows)


3. login as user1 to db1
psql -d db1 -h 192.168.56.200 -U user1 -W

4. I want to remove public schema in db1 but i get error not the owner ,
when I do \dn+

db1=> \dn+
                          List of schemas
  Name  |  Owner   |  Access privileges   |      Description
--------+----------+----------------------+------------------------
 public | postgres | postgres=UC/postgres+| standard public schema
        |          | =UC/postgres         |
(1 row)


Question?
1. since I create database with user1 as owner  , why is it the public
schema created in db1 not own by user1?







--
View this message in context: http://postgresql.1045698.n5.nabble.com/create-database-with-owner-tp5752623.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.