Thread: How to change a view's owner in postgres(is it possible?)

<div dir="ltr"><br /><div class="gmail_quote"><div dir="ltr"><br />Dear all,<br /><br />We can change the owner of a
tbalelike this<br /><br /></div></div>alter table tbl_year_end owner to anoop;<br /><br />Is it possible to change the
ownername of a  view through sql?<br /><br /><br /><br /></div> 

On Fri, Aug 1, 2008 at 3:16 AM, Anoop G <anoopmadavoor@gmail.com> wrote:

> We can change the owner of a tbale like this
> alter table tbl_year_end owner to anoop;
> Is it possible to change the owner name of a  view through sql?


Here is what the "notes:" section of
http://www.postgresql.org/docs/8.3/interactive/sql-alterview.html
says:

Notes
Some variants of ALTER TABLE can be used with views as well; for
example, to rename a view it is also possible to use ALTER TABLE
RENAME. To change the schema or owner of a view, you currently must
use ALTER TABLE.


So you would simple use the ALTER TABLE statement to perform this operation.

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug