Re: How to remove the partition from table .

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: Rakesh Nashine <nashine(dot)rakesh(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to remove the partition from table .
Date: 2022-10-25 11:09:25
Message-ID: 568082632.421153.1666696165054@office.mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 25/10/2022 12:47 CEST Rakesh Nashine <nashine(dot)rakesh(at)gmail(dot)com> wrote:
>
> We would like to remove the partition from one of the tables , although that
> partition has some business data. Now business doesn't need that partition
> any more .. How could we remove it? although they need the data .

Detach the partition:

https://www.postgresql.org/docs/15/sql-altertable.html#SQL-ALTERTABLE-DETACH-PARTITION

--
Erik

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-10-25 13:29:20 Re: How to remove the partition from table .
Previous Message Rakesh Nashine 2022-10-25 10:47:16 How to remove the partition from table .