Thread: Altering Database/Table Ownership

Have you logged into Postgres as the System Administration account or your
account has system admin privelges??

create table test(number integer null);
CREATE
test=# \d
  List of relations
 Name | Type  | Owner
------+-------+-------
 test | table | vlad
(1 row)


test=# alter table test owner to nobody;
ALTER
test=# \d
   List of relations
 Name | Type  | Owner
------+-------+--------
 test | table | nobody
(1 row)

test=# select version();
                           version
-------------------------------------------------------------
 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

HTH

Darren Ferguson

On Tue, 30 Apr 2002, Jillian Carroll wrote:

> How can I do this?
>
> ALTER TABLE users OWNER TO smith
>
> Isn't working.
>
> Can anybody point me in the right direction?  I can't find anything other
> than this in the docs or on Deja.
>
> Thanks!
>
> --
> Jillian
>