MIME-Version: 1.0
From: Gambhir Singh <gambhir.singh05@gmail.com>
Date: Mon, 11 May 2026 18:01:05 +0530
Message-ID: 
 <CAHOGQfVo0FWX8mS9FLTmpDOb5XC5-T4qx4ouhw0wOfNeLdahsA@mail.gmail.com>
Subject: Alter the datatype on all tables present in the database (bigint to
 varchar)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
 pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000da0f69065189ed13"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHOGQfVo0FWX8mS9FLTmpDOb5XC5-T4qx4ouhw0wOfNeLdahsA%40mail.gmail.com>
Precedence: bulk

--000000000000da0f69065189ed13
Content-Type: text/plain; charset="UTF-8"

Hi,

Please help me with the best way to change the datatype of a column in a
all tables in DB from bigint to varchar. Please consider the following
facts.


   - DB Size - 75 TB
   - Number of tables - ~100
   - Some tables are partitioned and some are not partitioned.
   - All partitioned tables are big in size.
   - For reference, the largest partition size is 4 TB, similarly the size
   of 10-12 partitions ranges between 1 to 4 TB.
   - We have indexes and FK on tables.
   - Physical Replication is configured with 2 standby DBs.


-- 
Thanks & Regards
Gambhir Singh

--000000000000da0f69065189ed13
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div class=3D"gmail_default" style=3D"font-family:tah=
oma,sans-serif;font-size:small;color:rgb(0,0,0)">Hi,</div><div class=3D"gma=
il_default" style=3D"font-family:tahoma,sans-serif;font-size:small;color:rg=
b(0,0,0)"><br></div><div class=3D"gmail_default" style=3D"font-family:tahom=
a,sans-serif;font-size:small;color:rgb(0,0,0)"><span style=3D"font-family:A=
rial,Helvetica,sans-serif;color:rgb(34,34,34)">Please help me with the best=
 way to change the datatype of a column in a all tables in DB from bigint t=
o varchar. Please consider the following facts.</span></div><br><ul><li>DB =
Size - 75 TB</li><li>Number of tables - ~100</li><li>Some tables are partit=
ioned and some are not partitioned.</li><li>All partitioned tables are big =
in size.</li><li>For reference, the largest partition size is 4 TB, similar=
ly the size of 10-12 partitions ranges between 1 to 4 TB.</li><li>We have i=
ndexes and FK on tables.=C2=A0</li><li>Physical Replication is configured w=
ith 2 standby DBs.=C2=A0=C2=A0</li></ul></div><div><br></div><span class=3D=
"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_sign=
ature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr">Thanks &amp; Reg=
ards<br>Gambhir Singh<br><br></div></div></div>

--000000000000da0f69065189ed13--