Skip site navigation (1) Skip section navigation (2)

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

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Anoop G" <anoopmadavoor(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to change a view's owner in postgres(is it possible?)
Date: 2008-08-05 17:02:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
On Fri, Aug 1, 2008 at 3:16 AM, Anoop G <anoopmadavoor(at)gmail(dot)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

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

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

Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)

In response to

pgsql-sql by date

Next:From: Ryan WallaceDate: 2008-08-05 17:19:02
Subject: Single Quote in tsquery
Previous:From: Richard BroersmaDate: 2008-08-05 15:33:13
Subject: Re: more than 1000 connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group