On 09/03/2014 10:24 AM, Emi Lu wrote:
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?
So schema2, schema1 are user names?
If so include the names in the .pgpass file:
http://www.postgresql.org/docs/9.3/static/libpq-pgpass.html
Thanks a lot!
Emi
--
Note:
. Views need to be created under difference schemas and created by that
schema owner for now.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
