Re: rename table between schema with one command

2019-07-24 Thread David G. Johnston
On Wednesday, July 24, 2019, Alex wrote: > 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. > No. AFAIK alter table is the obly sql command that can do those

rename table between schema with one command

2019-07-24 Thread Alex
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.