Re: alter the datatype of Partition Key - Mailing list pgsql-admin

From Gambhir Singh
Subject Re: alter the datatype of Partition Key
Date
Msg-id CAHOGQfXU5Lks_xizETjXvnENFHafT2xT3wOB0D=8X_bL_as4rA@mail.gmail.com
Whole thread Raw
In response to alter the datatype of Partition Key  (Gambhir Singh <gambhir.singh05@gmail.com>)
List pgsql-admin
Please help me on this

Thanks & Regards
Gambhir Singh



On Mon, 16 Jun 2025 at 12:45, Gambhir Singh <gambhir.singh05@gmail.com> wrote:
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

pgsql-admin by date:

Previous
From: Christophe Courtois
Date:
Subject: Re: alter the datatype of Partition Key
Next
From: ROHIT SACHDEVA
Date:
Subject: Regarding Partition