Thanks for the help. it worked
On Wed, Dec 1, 2010 at 11:10 AM, Gary Chambers wrote:
> akp geek,
>
> > 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
akp geek,
> 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?
In t
Hi All -
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?
Th
