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

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/i

Re: [SQL] How to change a view's owner in postgres

On Fri, Aug 1, 2008 at 11:41 AM, Anoop G <[EMAIL PROTECTED]> wrote: > How to change a view's owner in postgres? ALTER TABLE view_name OWNER TO new_owner; -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-s

[SQL] How to change a view's owner in postgres(is it possible?)

Dear all, 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?

[SQL] How to change a view's owner in postgres

Dear All, How to change a view's owner in postgres? thanks in advance: Anoop