PosgtreSQL - Change multiple fields collation in one query
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.