Re: rename table between schema with one command

"David G. Johnston" <[email protected]> Wed, 24 Jul 2019 23:22:58 -0700

Newsgroups	gmane.comp.db.postgresql.general
Message-ID	<CAKFQuwYrSGZkbEzJOvoROFjSg=Yh7HumJaLgZj-FvqZzQ3ewaQ@mail.gmail.com>

On Wednesday, July 24, 2019, Alex <[email protected]> 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 things and
the syntax does not provide a way to combine the two into a single
executable command.

Out of curosity, why do you ask?

David J.