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

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: How to change a view's owner in postgres(is it possible?)
Дата
Msg-id 396486430808051002p12cd577m4bd55f2b25033f4c@mail.gmail.com
обсуждение исходный текст
Ответ на How to change a view's owner in postgres(is it possible?)  ("Anoop G" <anoopmadavoor@gmail.com>)
Список pgsql-sql
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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Richard Broersma"
Дата:
Сообщение: Re: more than 1000 connections
Следующее
От: Ryan Wallace
Дата:
Сообщение: Single Quote in tsquery