CREATE OR REPLACE VIEW food600.sfood_dat
 AS
 SELECT food_dat.id,
    food_dat.id_menu,
    food_dat.pgm,
    food_dat.pgm_param,
    food_dat.pgm_path,
    food_dat.dat_path,
    food_dat.cen_path,
    food_dat.c_data,
    food_dat.id_zkratka,
    food_dat.c_stredisk,
    food_dat.priority,
    food_dat.skupina,
    food_dat.comment,
    food_dat.bour_skup,
    food_dat.setup_skup,
    food_dat.prava_skup,
    food_dat.stredskup,
    food_dat.a1,
    food_dat.a2,
    food_dat.a3,
    food_dat.a4,
    food_dat.a5,
    food_dat.a6,
    food_dat.a7,
    food_dat.a8,
    food_dat.a9,
    food_dat.b1,
    food_dat.b2,
    food_dat.b3,
    food_dat.b4,
    food_dat.b5,
    food_dat.b6,
    food_dat.b7,
    food_dat.b8,
    food_dat.b9,
    food_dat.c1,
    food_dat.c2,
    food_dat.c3,
    food_dat.c4,
    food_dat.c5,
    food_dat.c6,
    food_dat.c7,
    food_dat.c8,
    food_dat.c9,
    food_dat.id_klapky,
    food_dat.pozadi,
    food_dat.defa_prn,
    food_dat.zadan_prn,
    food_dat.era_cen,
    food_dat.typ_inst,
    food_dat.kont_dbf
   FROM food600.food_dat
UNION
 SELECT ''::character(2) AS id,
    ''::character(10) AS id_menu,
    ''::character(12) AS pgm,
    ''::character(12) AS pgm_param,
    ''::character(30) AS pgm_path,
    ''::character(30) AS dat_path,
    ''::character(30) AS cen_path,
    0 AS c_data,
    ''::character(30) AS id_zkratka,
    0 AS c_stredisk,
    0 AS priority,
    ''::character(1) AS skupina,
    ''::character(50) AS comment,
    ''::character(2) AS bour_skup,
    ''::character(2) AS setup_skup,
    ''::character(2) AS prava_skup,
    ''::character(4) AS stredskup,
    ''::character(2) AS a1,
    ''::character(2) AS a2,
    ''::character(2) AS a3,
    ''::character(2) AS a4,
    ''::character(2) AS a5,
    ''::character(2) AS a6,
    ''::character(2) AS a7,
    ''::character(2) AS a8,
    ''::character(2) AS a9,
    ''::character(2) AS b1,
    ''::character(2) AS b2,
    ''::character(2) AS b3,
    ''::character(2) AS b4,
    ''::character(2) AS b5,
    ''::character(2) AS b6,
    ''::character(2) AS b7,
    ''::character(2) AS b8,
    ''::character(2) AS b9,
    ''::character(2) AS c1,
    ''::character(2) AS c2,
    ''::character(2) AS c3,
    ''::character(2) AS c4,
    ''::character(2) AS c5,
    ''::character(2) AS c6,
    ''::character(2) AS c7,
    ''::character(2) AS c8,
    ''::character(2) AS c9,
    ''::character(2) AS id_klapky,
    ''::character(30) AS pozadi,
    ''::character(2) AS defa_prn,
    ''::character(2) AS zadan_prn,
    ''::character(5) AS era_cen,
    0::smallint AS typ_inst,
    0::smallint AS kont_dbf;
