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