Re: Object movement
| От | Daulat |
|---|---|
| Тема | Re: Object movement |
| Дата | |
| Msg-id | CALfOM6+bqyUVZEr6B1te9DvygiYAgxGrknRzb=J7YQBd03t=1w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Object movement (Holger Jakobs <holger@jakobs.com>) |
| Список | pgsql-admin |
Thanks Holger !
I think we can do it as below.
\c <database>
alter table all in tablespace tbs1 set tablespace tbs2;
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 по дате отправления: