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
use ALTER TABLE.
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 Wallace||Date: 2008-08-05 17:19:02|
|Subject: Single Quote in tsquery|
|Previous:||From: Richard Broersma||Date: 2008-08-05 15:33:13|
|Subject: Re: more than 1000 connections|