Postgres Pro
Downloads
Home   >   mailing lists

Re: Object movement - Mailing list pgsql-admin

From Daulat
Subject Re: Object movement
Date
Msg-id CALfOM6+bqyUVZEr6B1te9DvygiYAgxGrknRzb=J7YQBd03t=1w@mail.gmail.com
Whole thread Raw
In response to Re: Object movement  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
Thanks Holger !
I think we can do it as below.

\c <database>
 alter table all in tablespace tbs1 set tablespace tbs2;
 select schemaname,tablename,tablespace,tableowner from pg_tables where tablespace=' tbs2';


On Wed, Feb 16, 2022 at 2:10 PM Holger Jakobs <holger@jakobs.com> wrote:
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

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Differential backup in database migration
Next
From: Marco DE BOOIJ
Date:
Subject: Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"