Changing owner objects

Hi,

Is there an easy way (in one go) to change the owner of all database objects with PG Admin ?

I am creating a schema with a script that assign the objects owner to login (I mean conection role) A .
Then I switch the schema owner to login (/conection role) B.

But the objects are still owned by A.
Is there an easy way in PG Admin to change the owner obejcts from A to B ?

I have created a little script doing this but it's a shame I can not do this easily in PG Admin.
(because my script is still a bit of a manual process as I don't know the PG database well enough to have a completely automatic script).

May be, we changing the schema owner, PG Admin could prompt whether the schema objects owner should be changed as well (for each objects).

Cheers,
L(at)u
The Computing Froggy

___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com