Reputation: 727
On mysql supposing I want to rename table buildings from db1 to db2
rename table db1.buildings to db2.buildings;
On postgres I known how to rename a table inside the same db
alter table buildings rename to newbuildings;
Is possible to rename from db1 to db2 on postgres?
Upvotes: 0
Views: 93