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: 396486430808051002p12cd577m4bd55f2b25033f4c@mail.gmail.com (view raw or flat)
Thread:
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
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

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-2014 The PostgreSQL Global Development Group