Re: How to ALTER EXTENSION name OWNER TO new_owner ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: "Colin 't Hart" <colinthart(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to ALTER EXTENSION name OWNER TO new_owner ?
Date: 2017-08-09 16:10:11
Message-ID: 5665.1502295011@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general

Melvin Davidson <melvin6925(at)gmail(dot)com> writes:
> *UPDATE pg_extension SET extowner = {oid_of_new_owner} WHERE extowner =
> {oid_from_above_statement};*

Note you'll also have to modify the rows in pg_shdepend that reflect
this ownership property.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2017-08-09 16:19:52 Re: How to ALTER EXTENSION name OWNER TO new_owner ?
Previous Message Melvin Davidson 2017-08-09 15:40:20 Re: How to ALTER EXTENSION name OWNER TO new_owner ?