Postgres Pro
Downloads
Home   >   mailing lists

Re: Object movement - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: Object movement
Date
Msg-id 2e2cd935-30ee-f795-735a-9b66090f4e0a@jakobs.com
Whole thread Raw
In response to Object movement  (Daulat <daulat.dba@gmail.com>)
Responses Re: Object movement  (Daulat <daulat.dba@gmail.com>)
List pgsql-admin
Tree view 
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
Attachment

pgsql-admin by date:

Previous
From: Daulat
Date:
Subject: Object movement
Next
From: Alex Balashov
Date:
Subject: Differential backup in database migration