[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Altering Database/Table Ownership
From:       Darren Ferguson <darren () crystalballinc ! com>
Date:       2002-04-30 19:57:54
[Download RAW message or body]

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
> 


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html
[prev in list] [next in list] [prev in thread] [next in thread]