| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Peter Darley" <pdarley(at)kinesis-cem(dot)com> |
| Cc: | "Pgsql-General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Changing ownership of objects |
| Date: | 2002-05-28 22:47:59 |
| Message-ID: | 17593.1022626079@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
"Peter Darley" <pdarley(at)kinesis-cem(dot)com> writes:
> When I was young and foolish and setting up my DB initially I ended up with
> the objects in my DB owned by random users. I'd like to write a script to
> change the user for all objects to be the same, but I don't see any way to
> change the ownership of sequences. Any ideas?
ALTER TABLE OWNER should work on sequences (also indexes and views).
At least in 7.2 or later (didn't look at earlier versions). You could
also just poke pg_class.relowner ;-)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua b. Jore | 2002-05-28 23:06:36 | Re: Changing ownership of objects |
| Previous Message | Peter Darley | 2002-05-28 21:36:39 | Changing ownership of objects |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua b. Jore | 2002-05-28 23:06:36 | Re: Changing ownership of objects |
| Previous Message | Peter Darley | 2002-05-28 21:36:39 | Changing ownership of objects |