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
