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

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: drop/create/alter amongst difference schemas as non-super user
Date: 2014-09-03 17:24:51
Message-ID: 54074EE3.1050705@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-09-03 19:10:19 Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Previous Message Adrian Klaver 2014-09-03 16:33:05 Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.