I need to change column collation from default to "C.utf8".
This is the statement I am using:
ALTER TABLE
ALTER COLUMN 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
Asked by kravb
(179 rep)
Jan 31, 2024, 02:15 PM
Last activity: Mar 4, 2025, 03:09 PM
Last activity: Mar 4, 2025, 03:09 PM