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

Reply via email to