Postgres Pro
Downloads
Home   >   mailing lists

Change column datatype from INT to BIGINT - Mailing list pgsql-admin

From srinivasan s
Subject Change column datatype from INT to BIGINT
Date
Msg-id CAOEeMcWi=XXfaq1C0wC3jzRYQFez-voXbvsixJJnXBYfU9RyKg@mail.gmail.com
Whole thread Raw
Responses Re: Change column datatype from INT to BIGINT
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Dynamically generate varying Number of Column Headers from the Row data
Next
From: Michael Guissine
Date:
Subject: Re: Change column datatype from INT to BIGINT