Re: How to change the table owner? - Mailing list pgsql-admin

> 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