Grant command help -- postgres

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Grant command help -- postgres
Date: 2010-12-01 15:06:13
Message-ID: AANLkTi=yVgM5PwunvqUotG9d0TtCR6RxrC5JzkVCdvFJ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks for the help
Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Samba 2010-12-01 15:10:11 Re: Stalled post to pgsql-general
Previous Message Samba 2010-12-01 15:03:09 plpgsql : looping over multidimensional array : getting NULL for subdimension