New answers tagged collation
There isn't a single SQL command that will do that for you. You can write a loop in a different language, using the results from SELECT table_name, column_name FROM information_schema.columns WHERE table_schema IN ('your_schemas') AND data_type = 'text' AND collation_name IS NULL; or similar.
The documentation often gives you an answer to such questions. Like in this case, too: The operator classes text_pattern_ops, varchar_pattern_ops, and bpchar_pattern_ops support B-tree indexes on the types text, varchar, and char respectively. The difference from the default operator classes is that the values are compared strictly character by ...
Top 50 recent answers are included