How to change all owners on all objects in a schema

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: How to change all owners on all objects in a schema
Date: 2011-06-23 15:59:06
Message-ID: B75CD08C73BD3543B97E4EF3964B7D70077BB4@CITESMBX2.ad.uillinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgreSQL: 9.0.x

How do I change the ownership of all objects within a schema from X to Y? The objects within each schema would be tables and sequences.

Thanks,

Lance Campbell

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kasia Tuszynska 2011-06-23 17:47:25 C collation and Template 1
Previous Message Achilleas Mantzios 2011-06-22 08:14:14 Re: dump from 9.0 to 8.3