I need to change column collation from default to "C.utf8".
This is the statement I am using:
ALTER TABLE <table_name>
ALTER COLUMN <column_name> SET DATA TYPE VARCHAR COLLATE "C.utf8";
The issue is that
SET DATA TYPE is causing errors as there are views and triggers that rely on that specific column. I would rather not have to drop and recreate views and triggers and touch a lot of additional code-base. Is there a syntax for updating collation without requiring SET DATA TYPE?
Postgres version: 14.10