How to change all owners on all objects in a schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: How to change all owners on all objects in a schema
From: "Campbell, Lance" <lance@xxxxxxxxxxxx>
Date: Thu, 23 Jun 2011 15:59:06 +0000
Accept-language: en-US
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx
Thread-index: AcwxvnrOfgD+pKDoRcmoUIJVGa/NoQ==
Thread-topic: How to change all owners on all objects in a schema

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

Follow-Ups:
- Re: How to change all owners on all objects in a schema
  - From: Kevin Grittner

Prev by Date: Re: dump from 9.0 to 8.3
Next by Date: C collation and Template 1
Previous by thread: dump from 9.0 to 8.3
Next by thread: Re: How to change all owners on all objects in a schema
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux