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

[Emi Lu <emilu@xxxxxxxxxxxxxxxxx>]

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.




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general