On Mon, 2020-09-28 at 11:45 +0200, Paul Förster wrote: > > Your best bet is to manually change the definition of all columns to use the new collation. > > psql's \gexec may help. > > but then I'd have to do a reindex anyway, right? My goal was to avoid the reindex altogether, if possible. That couldn't be avoided anyway if you change the collation no matter if you do it on the database or on the column level. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
