ALTER TABLE public.general_tag
  ADD COLUMN name_for_sort text NOT NULL DEFAULT '';
DROP VIEW IF EXISTS public.unit_to_general_tag_view;
CREATE OR REPLACE VIEW public.unit_to_general_tag_view AS
SELECT
   G.id as id_general_tag, name, name_for_sort, R.id_unit, G.id_user
FROM public.general_tag as G
   JOIN public.many_unit_has_many_general_tag as R ON G.id = R.id_general_tag;