postgresql 12.3 convert existing DB to use case-insensitive collation?

2 votes

1 answer

1068 views

                          postgresql 12.3 in a container with Alpine Linux 3.10

I would like to convert an existing DB to use case-insensitive collation. Is it possible? I mean, without dropping it and recreating from scratch.
Also, instead of setting this for the whole db, can I add this collation to a field in an existing table, or to a table?
                        

Asked by SwissNavy (121 rep)

Aug 7, 2020, 12:34 PM
Last activity: Sep 27, 2022, 04:03 AM

postgresql 12.3 convert existing DB to use case-insensitive collation?

Related Questions