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

From Gambhir Singh
Subject alter the datatype of Partition Key
Date
Msg-id CAHOGQfUDcr+ZRJ=q+7uNgU+qFzRx6uuwbzHsfyXtFxd9PYAV9Q@mail.gmail.com
Whole thread Raw
Responses Re: alter the datatype of Partition Key
List 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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: extensive data use setting in production
Next
From: Christophe Courtois
Date:
Subject: Re: alter the datatype of Partition Key