Postgres Pro
Downloads
Home   >   mailing lists

Re: How to remove the partition from table . - Mailing list pgsql-general

From Erik Wienhold
Subject Re: How to remove the partition from table .
Date
Msg-id 568082632.421153.1666696165054@office.mailbox.org
Whole thread Raw
In response to How to remove the partition from table .  (Rakesh Nashine <nashine.rakesh@gmail.com>)
List pgsql-general
Tree view 
> On 25/10/2022 12:47 CEST Rakesh Nashine <nashine.rakesh@gmail.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

pgsql-general by date:

Previous
From: Rakesh Nashine
Date:
Subject: How to remove the partition from table .
Next
From: Ron
Date:
Subject: Re: How to remove the partition from table .