Sqitch create view templates for pg engine

pg_deploy_create_view.tmpl

-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]

BEGIN;

SET SEARCH_PATH TO [% IF schema %][% schema %],[% END %]public;
CREATE OR REPLACE VIEW [% IF name %][% name %][% ELSE %][% change %][% END %] AS (
  SELECT * FROM [% IF source; source %][% ELSE %]XXX SOURCE[% END %]
);

--GRANT SELECT ON TABLE [% IF name %][% name %][% ELSE %][% change %][% END %] TO PUBLIC;

COMMIT;

pg_revert_create_view.tmpl

-- Revert [% project %]:[% change %] from [% engine %]

BEGIN;

SET SEARCH_PATH TO [% IF schema %][% schema %],[% END %]public;
DROP VIEW [% IF name %][% name %][% ELSE %][% change %][% END %] RESTRICT;

COMMIT;

pg_verify_create_view.tmpl

-- Verify [% project %]:[% change %] on [% engine %]

BEGIN;

SELECT '[% IF schema; schema %].[% END %][% IF name %][% name %][% ELSE %][% change %][% END %]'::REGCLASS;

ROLLBACK;