>>If you use PostgreSQL 8.2, you can
>> REASSIGN OWNED BY A TO B;
Good but I am using 8.1
>>We aren't sure that all objects in this schema are owned by the same
>>user. But perhaps we can add some code to "emulate" REASSIGN OWNED for
>>older PostgreSQL releases.
That will be great !
Hav
Laurent ROCHE a ecrit le 09/03/2007 12:58:
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 r
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
