Обсуждение: How to change the table owner?

I must be missing this somewhere in the documentation. How can I change
the owner of a table?

Thanks.
-Tony

ALTER TABLE ... OWNER in 7.1.

> I must be missing this somewhere in the documentation. How can I change
> the owner of a table?
>
> Thanks.
> -Tony
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

> Bruce Momjian wrote:
>
> > ALTER TABLE ... OWNER in 7.1.
> >
> > > I must be missing this somewhere in the documentation. How can I change
> > > the owner of a table?
> > >
> > > Thanks.
> > > -Tony
>
> Sorry. I should have specified that I still using 7.0.3. Do I have to go into
> pg_table or something?

Yes, pg_class.relowner.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruce Momjian wrote:

> ALTER TABLE ... OWNER in 7.1.
>
> > I must be missing this somewhere in the documentation. How can I change
> > the owner of a table?
> >
> > Thanks.
> > -Tony

Sorry. I should have specified that I still using 7.0.3. Do I have to go into
pg_table or something?

-Tony