Ramesh H R <ramesh(at)easi(dot)soft(dot)net> 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