On Fri, Aug 1, 2008 at 3:16 AM, Anoop G <[EMAIL PROTECTED]> 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql