\pset null _null_
\pset format unaligned
SELECT ddlx_script('test_class_v'::regclass);
ddlx_script
BEGIN;

/*
DROP VIEW test_class_v_opt2;
DROP VIEW test_class_v2;

DROP VIEW test_class_v;
*/

-- Type: VIEW ; Name: test_class_v; Owner: postgres

CREATE OR REPLACE VIEW test_class_v AS
 SELECT test_class_r.a,
    test_class_r.b,
    test_class_r.c,
    test_class_r.d,
    test_class_r.e,
    test_class_r.f,
    test_class_r.g,
    test_class_r.h,
    test_class_r.v
   FROM test_class_r;

COMMENT ON VIEW test_class_v IS NULL;

ALTER VIEW test_class_v OWNER TO postgres;
GRANT SELECT ON test_class_v TO PUBLIC;

-- DEPENDANTS

-- Type: VIEW ; Name: test_class_v2; Owner: postgres

CREATE OR REPLACE VIEW test_class_v2 AS
 SELECT test_class_v.a,
    test_class_v.b,
    test_class_v.c,
    test_class_v.d,
    test_class_v.e,
    test_class_v.f,
    test_class_v.g,
    test_class_v.h,
    test_class_v.v
   FROM test_class_v;

COMMENT ON VIEW test_class_v2 IS NULL;

ALTER VIEW test_class_v2 OWNER TO postgres;
GRANT SELECT (a) ON test_class_v2 TO PUBLIC;
GRANT SELECT (b) ON test_class_v2 TO PUBLIC;
GRANT SELECT (c) ON test_class_v2 TO PUBLIC;

-- Type: VIEW ; Name: test_class_v_opt2; Owner: postgres

CREATE OR REPLACE VIEW test_class_v_opt2 AS
 SELECT test_class_v.a,
    test_class_v.b,
    test_class_v.c,
    test_class_v.d,
    test_class_v.e,
    test_class_v.f,
    test_class_v.g,
    test_class_v.h,
    test_class_v.v
   FROM test_class_v
  ORDER BY test_class_v.a;

COMMENT ON VIEW test_class_v_opt2 IS NULL;

ALTER VIEW test_class_v_opt2 SET (security_barrier='true');

ALTER VIEW test_class_v_opt2 OWNER TO postgres;

END;

(1 row)