alter the datatype of Partition Key

From: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: alter the datatype of Partition Key
Date: 2025-06-16 07:15:18
Message-ID: CAHOGQfUDcr+ZRJ=q+7uNgU+qFzRx6uuwbzHsfyXtFxd9PYAV9Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We have a partition table with partitioning type range and got the
requirement from the application team to alter the datatype of partitioning
key from bigint to varchar. Please suggest to me the way how this can be
achieved.

Data volume is quite huge in the table. ~50 Billion rows

--
Thanks & Regards
Gambhir Singh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christophe Courtois 2025-06-16 08:13:59 Re: alter the datatype of Partition Key
Previous Message Laurenz Albe 2025-06-16 05:37:44 Re: extensive data use setting in production