ALTERING COLLATION

From: aditya desai <admad123(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: ALTERING COLLATION
Date: 2021-12-30 07:42:24
Message-ID: CAN0SRDEC5bFObN0_U_PagctbYbi0iu-riXEZ3S1nzaQWiY1Ytg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I had to alter COLLATION of one of the table column as shown below due to
business requirements.

alter TABLE workflow alter status_id TYPE character varying(10) COLLATE "C"

Is there any way to do this at server level?

Regards,
Aditya.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2021-12-30 15:58:28 Re: ALTERING COLLATION
Previous Message Tom Lane 2021-12-17 17:58:55 Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links