drop/create/alter amongst difference schemas as non-super user

Поиск
Список
Период
Сортировка
От Emi Lu
Тема drop/create/alter amongst difference schemas as non-super user
Дата
Msg-id 54074EE3.1050705@encs.concordia.ca
обсуждение исходный текст
Ответы Re: drop/create/alter amongst difference schemas as non-super user  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hello,

As non-postgre user, may I know is there a way to combine
drop/create/alter amongst difference schemas please?

Something similar to:
==============
Begin;
    drop schema1.v1;
    \c - schema2;
    drop schema2.v2;
    \c - schema1;
    alter table schema1.t1 alter column...;
    create schema1.v1;
    \c - schema2;
    create schema2.v2;
commit;

This way the commit would complain and have to type pwd for diff schema
owners. Is there a better way of doing this?

Thanks a lot!
Emi
--
Note:
. Views need to be created under difference schemas and created by that
schema owner for now.




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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.