for example we have table t1 under schema s1. can I rename it to s2.t2 with one command.
currently I can do: alter table s1.t1 set schema s2; alter table s2.t1 rename to t2.
for example we have table t1 under schema s1. can I rename it to s2.t2 with one command.
currently I can do: alter table s1.t1 set schema s2; alter table s2.t1 rename to t2.