Postgres Pro
Downloads
Home   >   mailing lists

ALTERING COLLATION - Mailing list pgsql-sql

From aditya desai
Subject ALTERING COLLATION
Date
Msg-id CAN0SRDEC5bFObN0_U_PagctbYbi0iu-riXEZ3S1nzaQWiY1Ytg@mail.gmail.com
Whole thread Raw
Responses Re: ALTERING COLLATION  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view
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.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links
Next
From: Tom Lane
Date:
Subject: Re: ALTERING COLLATION