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

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(dot)klaver(at)aklaver(dot)com