I created a schema , I used pg_restore with postgres as user and restored every thing to the new schema I created. Now I want to change the owner ship of the schema and all its objects to a different user other than postgres. Is it possible to do that with one command?
Thanks for the help
Regards