Change column datatype from INT to BIGINT

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Change column datatype from INT to BIGINT
From: srinivasan s <srinioracledba7@xxxxxxxxx>
Date: Mon, 11 Mar 2024 22:41:53 +0530

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

Follow-Ups:
- Re: Change column datatype from INT to BIGINT
  - From: Michael Guissine

Prev by Date: Dynamically generate varying Number of Column Headers from the Row data
Next by Date: Re: Change column datatype from INT to BIGINT
Previous by thread: Dynamically generate varying Number of Column Headers from the Row data
Next by thread: Re: Change column datatype from INT to BIGINT
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux