Search code examples
mysqlpostgresqltable-rename

postgresql: is possible to rename a table from db1 to db2?

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?

Solution

  • I have found another solution

    pg_dump db1 -t buildings| psql db2