CREATE OR REPLACE VIEW "mnadmin"."test" (
    id,
    ats,
    dslam,
    port,
    kros,
    phone,
    adress,
    abonent,
    datawork,
    kod,
    statusconnect,
    typeconnect,
    groups,
    city,
    spec,
    modem,
    mserial,
    outcospp,
    incospp,
    aboncontact,
    abonphone,
    abonip,
    lanip,
    wanip,
    nodename,
    abonlogin,
    action,
    tarifplan,
    snrdown,
    snrup,
    shleyf,
    linelength,
    pristroy,
    kabel,
    rg11,
    rozet11,
    expl,
    who,
    comments)
AS
SELECT abonent_test.id, abonent_test.ats, abonent_test.dslam,
    abonent_test.port, abonent_test.kros, abonent_test.phone,
    abonent_test.adress, abonent_test.abonent, abonent_test.datawork,
    abonent_test.kod, abonent_test.statusconnect, abonent_test.typeconnect,
    abonent_test.groups, abonent_test.city, abonent_test.spec,
    abonent_test.modem, abonent_test.mserial, abonent_test.outcospp,
    abonent_test.incospp, abonent_test.aboncontact, abonent_test.abonphone,
    abonent_test.abonip, abonent_test.lanip, abonent_test.wanip,
    abonent_test.nodename, abonent_test.abonlogin, abonent_test."action",
    abonent_test.tarifplan, abonent_test.snrdown, abonent_test.snrup,
    abonent_test.shleyf, abonent_test.linelength, abonent_test.pristroy,
    abonent_test.kabel, abonent_test.rg11, abonent_test.rozet11,
    abonent_test.expl, abonent_test.who, abonent_test.comments
FROM mnadmin.abonent_test
WHERE ((abonent_test.city)::text = 'Õìåëüíèöüêèé'::text);

INSERT INTO mnadmin.test (id, ats, dslam, port, kros, phone, adress, abonent, datawork, kod, statusconnect, typeconnect, groups, city, spec, modem, mserial, outcospp, incospp, aboncontact, abonphone, abonip, lanip, wanip, nodename, abonlogin, "action", tarifplan, snrdown, snrup, shleyf, linelength, pristroy, kabel, rg11, rozet11, expl, who, comments) 
VALUES (new.id, new.ats, new.dslam, new.port, new.kros, new.phone, new.adress, new.abonent, new.datawork, new.kod, new.statusconnect, new.typeconnect, new.groups, new.city, new.spec, new.modem, new.mserial, new.outcospp, new.incospp, new.aboncontact, new.abonphone, new.abonip, new.lanip, new.wanip, new.nodename, new.abonlogin, new."action", new.tarifplan, new.snrdown, new.snrup, new.shleyf, new.linelength, new.pristroy, new.kabel, new.rg11, new.rozet11, new.expl, new.who, new.comments);