Change column datatype from INT to BIGINT

From: srinivasan s <srinioracledba7(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Change column datatype from INT to BIGINT
Date: 2024-03-11 17:11:53
Message-ID: CAOEeMcWi=XXfaq1C0wC3jzRYQFez-voXbvsixJJnXBYfU9RyKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everyone

Hope you’re doing good!

We need to change the data type of one of the columns in the large table
from INT to BIGINT because it reaches the maximum integer value. What is
the best way to do this conversion from INT to BIGINT with no downtime or
very minimal impact, I look forward to receiving help from the experts
here. Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Guissine 2024-03-11 17:33:36 Re: Change column datatype from INT to BIGINT
Previous Message M Sarwar 2024-03-11 16:57:43 Dynamically generate varying Number of Column Headers from the Row data