Thread: how to change table owner?

Hi, I need to change the owner of a few tables. What's the best
way to do this? Is it safe to modify the pg_tables table?

I'm running 6.5 (yes, I know it's old, but upgrading is not an
option right now :(

thanks!

-Kevin

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

Does anyone can tell where I can find doc on the plpgsql for trigger
and function?
TX
==============================
Marco GERMONI            E-mail:mgermoni@uniautomation.it
Field Engineering Manager
Uniautomation S.r.l.               tel.+39-06-514221
Via A. Di Bonaiuto, 39             fax +39-06-51422311
I-00142 Roma Italy                 GSM +39-348-9997186

Internet: www.uniautomation.it
==============================

mgermoni@uniautomation.it wrote:
>
> Does anyone can tell where I can find doc on the plpgsql for trigger
> and function?

See the section on procedural languages in the programmer's guide
(http://www.postgresql.org/users-lounge/docs/7.1/programmer/). Also
check Bruce Momijan's book (online at
http://www.postgresql.org/docs/aw_pgsql_book/) and perhaps look in
http://techdocs.postgresql.org/ at some examples in Roberto Mello's
cookbook or in my notes.

HTH

- Richard Huxton