Re: Object movement

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Object movement
Date: 2022-02-16 08:40:29
Message-ID: 2e2cd935-30ee-f795-735a-9b66090f4e0a@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am 16.02.22 um 09:36 schrieb Daulat:
> Hello,
>
> How can we move the object (tables etc.) of one database from another
> tablespace in postgres?
>
> Thanks

Move an object to a new tablespace:

ALTER objectName SET TABLESPACE newTablespace

You cannot move an object to a new database. You would have to re-create
it there.

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Balashov 2022-02-16 11:24:17 Differential backup in database migration
Previous Message Daulat 2022-02-16 08:36:51 Object movement