Home > mailing lists

How to change all owners on all objects in a schema - Mailing list pgsql-admin

From	Campbell, Lance
Subject	How to change all owners on all objects in a schema
Date	June 23, 2011 15:59:14
Msg-id	B75CD08C73BD3543B97E4EF3964B7D70077BB4@CITESMBX2.ad.uillinois.edu Whole thread Raw
Responses	Re: How to change all owners on all objects in a schema ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List	pgsql-admin

Tree view

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

pgsql-admin by date:

From: Achilleas Mantzios
Date: 22 June 2011, 08:14:24
Subject: Re: dump from 9.0 to 8.3

From: Kasia Tuszynska
Date: 23 June 2011, 17:53:58
Subject: C collation and Template 1

How to change all owners on all objects in a schema - Mailing list pgsql-admin

Previous

Next