Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to change column collation postgresql

Tags:

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?

like image 978
Logovsky Dmitry Avatar asked Sep 13 '19 13:09

Logovsky Dmitry

1 Answers

You can just alter column table

ALTER TABLE users ALTER COLUMN name SET DATA TYPE character varying(255) COLLATE "en_US"
like image 146
Logovsky Dmitry Avatar answered Oct 13 '22 01:10

Logovsky Dmitry
Sign in to Comment

Related questions

Django model field for PostgreSQL NUMERIC data type
Column definitions in ROWS FROM() with multiple unnest calls
What are the benefits of using Postgresql Daterange type instead of two Date fields?
Update row with value from previous row in a GROUP BY query in Postgres
Postgresql stored procedure return select result set
POSTGRESQL- Query has no destination for result data
How good is BDR for production Postgres sync?
Resize Shared buffer size in Postgresql hosted in AWS RDS
How should we name or map SQL tables from Postgres to Node?
Selecting where timestamp greater than with timezone
Postgres: Get number of days since date
Query to check postgresql database status
PostgreSQL: Fastest Index For Autocomplete
What is the right way to snyc/import tables from a postgres DB to elasticsearch?
put automatically password of user in pg_restore command line windows [duplicate]
Return inserted item's UUID back from Dapper/PostgreSQL
PostgreSQL FATAL: could not access file "pg_stat_statements": No such file or directory
How to get distinct polymorphic association
Django annotate count in JSONField with Postgres
How to use 'where id in' clauses with jackc/pgx?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!