Altering Database/Table Ownership
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
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:
Show quoted text
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