Re: 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
>