Postgres Pro
Downloads
Home   >   mailing lists

rename table between schema with one command - Mailing list pgsql-general

From Alex
Subject rename table between schema with one command
Date
Msg-id CAKU4AWraGbRNBrS=kO2e8cK1TGoK8vuBz+YN_tiX6PFO3+91-Q@mail.gmail.com
Whole thread Raw
Responses Re: rename table between schema with one command
List pgsql-general
Tree view
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. 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Running concurrent txns and measuring the timings in Postgres
Next
From: Guyren Howe
Date:
Subject: Re: Request for resolution || Support