Postgres Pro
Downloads
Home   >   mailing lists

Grant command help -- postgres - Mailing list pgsql-general

From akp geek
Subject Grant command help -- postgres
Date
Msg-id AANLkTi=yVgM5PwunvqUotG9d0TtCR6RxrC5JzkVCdvFJ@mail.gmail.com
Whole thread Raw
Responses Re: Grant command help -- postgres  (Gary Chambers <gwchamb@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Cannot start Postgres- FATAL: invalid cache id: 19
Next
From: Samba
Date:
Subject: Re: Stalled post to pgsql-general