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

2014-09-03 Thread Adrian Klaver
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 s

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

2014-09-03 Thread Emi Lu
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 schem