Sample Header Ad - 728x90

Change collation of column without SET DATA TYPE

0 votes
1 answer
561 views
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