CODEWITHSUNDEEP
postgresql
Logovskii Dmitrii
Logovskii Dmitrii

Reputation: 2973

How to change column collation postgresql

I have a database with default LC_COLLATE=C but I want to have different COLLATION to one column in my table, how to do it?

Upvotes: 13

Views: 19012

Answers (1)

Logovskii Dmitrii
Logovskii Dmitrii

Reputation: 2973

You can just alter column table

ALTER TABLE users ALTER COLUMN name SET DATA TYPE character varying(255) COLLATE "en_US"

Upvotes: 29

Related Questions