From: Tom Lane <tgl@sss.pgh.pa.us>
To: aditya desai <admad123@gmail.com>
cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: ALTERING COLLATION
In-reply-to: 
 <CAN0SRDEC5bFObN0_U_PagctbYbi0iu-riXEZ3S1nzaQWiY1Ytg@mail.gmail.com>
References: 
 <CAN0SRDEC5bFObN0_U_PagctbYbi0iu-riXEZ3S1nzaQWiY1Ytg@mail.gmail.com>
Comments: In-reply-to aditya desai <admad123@gmail.com>
	message dated "Thu, 30 Dec 2021 13:12:24 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2269503.1640879908.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 30 Dec 2021 10:58:28 -0500
Message-ID: <2269504.1640879908@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2269504.1640879908%40sss.pgh.pa.us>
Precedence: bulk

aditya desai <admad123@gmail.com> writes:
> I had to alter COLLATION of one of the table column as shown below due t=
o
> business requirements.
> alter TABLE workflow alter status_id  TYPE character varying(10) COLLATE=
 "C"
> Is there any way to do this at server level?

Where's the problem?

test=3D# create table workflow(status_id character varying(10) collate "en=
_US");
CREATE TABLE
test=3D# \d workflow
                      Table "public.workflow"
  Column   |         Type          | Collation | Nullable | Default =

-----------+-----------------------+-----------+----------+---------
 status_id | character varying(10) | en_US     |          | =


test=3D# alter TABLE workflow alter status_id  TYPE character varying(10) =
COLLATE "C";
ALTER TABLE
test=3D# \d workflow
                      Table "public.workflow"
  Column   |         Type          | Collation | Nullable | Default =

-----------+-----------------------+-----------+----------+---------
 status_id | character varying(10) | C         |          | =


			regards, tom lane