Search Postgresql Archives
rename table between schema with one command
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: rename table between schema with one command
From
: Alex <zhihui.fan1213@xxxxxxxxx>
Date
: Thu, 25 Jul 2019 12:52:06 +0800
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.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: rename table between schema with one command
From:
David G. Johnston
Prev by Date:
Re: Running concurrent txns and measuring the timings in Postgres
Next by Date:
Re: Request for resolution || Support
Previous by thread:
Sequential scan with composite type in primary key
Next by thread:
Re: rename table between schema with one command
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
