Ramesh H R <[EMAIL PROTECTED]> writes:
> Please, any one guide me how to change the ownership of the table?

There's an ALTER TABLE command for this in current sources, but I think
it's new in 7.1.  In older releases, you have to reach in by hand and
change the 'relowner' field of the table's pg_class row to match the
'usesysid' field of the pg_shadow entry for the desired new owner.

Working out the exact UPDATE command to use is left as an exercise
for the student ;-)

                        regards, tom lane

Reply via email to