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, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster