On Mon, Sep 13, 2010 at 12:24 PM, Carlos Mennens <carlos.mennens@xxxxxxxxx> wrote: > On Mon, Sep 13, 2010 at 1:57 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > I also noticed that I created a database called 'ide' in PostgreSQL as > the 'postgres' super user and I am trying to change the owner of the > database to me <cmennens> and when I run the following command, I > don't get an error but the owner doesn't appear to change for some > reason. What am I doing wrong? > > ide=# \c ide > psql (8.4.4) > You are now connected to database "ide". > > ide=# ALTER DATABASE ide OWNER TO cmennens; > ALTER DATABASE > > ide=# \dt > List of relations > Schema | Name | Type | Owner > --------+-------+-------+---------- > public | users | table | postgres > (1 row) > > Any ideas if I am missing something here? > > Thank you very much for all your support so far! The table owner isn't the same as the db owner. Whoever created the table owns it. Try \l to see a list of databases. Also note that instead of reassigning all those table owners by name you can grant membership of a user to that "role": grant ide to myrole; -- To understand recursion, one must first understand recursion. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
