CREATE OR REPLACE VIEW bn."Косметика линии" AS
 SELECT "COSMETICA_POLY".mslink,
    "COSMETICA_POLY".label_ AS "Подпись",
    "COSMETICA_POLY".comment_ AS "Комментарий",
    "COSMETICA_POLY".datechange AS "Дата создания",
    "COSMETICA_POLY".userdomain AS "Автор",
    "COSMETICA_POLY".shape
   FROM bn."COSMETICA_POLY";

-- Создание триггер функции
CREATE OR REPLACE FUNCTION bn.trigger_cosmetica_poly_i()  RETURNS trigger LANGUAGE plpgsql AS
$$
BEGIN
  NEW.mslink := nextval('bn."COSMETICA_POLY_mslink_seq"'::regclass);
  NEW.userdomain := 'Проверка';
  INSERT INTO bn."COSMETICA_POLY"(mslink, shape, label_, comment_, datechange, userdomain)
         VALUES (NEW.mslink, NEW.shape, NEW.label_, NEW.comment_, NEW.datechange, NEW.userdomain);
  RETURN NEW;
END
$$

-- Создание триггера
CREATE TRIGGER cosmetica_poly_i
INSTEAD OF INSERT ON bn."Косметика линии" FOR EACH ROW
EXECUTE PROCEDURE bn.trigger_cosmetica_poly_i ()