On Tue, 2024-06-11 at 23:15 +0200, Karsten Hilbert wrote: > maybe a naive question but I was unable to find an answer in > the fine manual (sv_SE being an example) > > Does running > > DROP COLLATION IF EXISTS pg_catalog."sv_SE" > > also remove the corresponding row from pg_collation (assuming > nothing depends on collation sv_SE) ? > > Experimentation seems to hint that way but I was unable to > confirm. Yes, that will delete a row from "pg_collation". System catalogs like "pg_collation" is where the database metadata are actually stored. Note that with DROP COLLATION you can only remove collations that belong to the encoding of your current database. Yours, Laurenz Albe
