Sqitch create schema templates for pg engine

pg_deploy_create_schema.tmpl

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

BEGIN;

CREATE SCHEMA [% IF name %][% name %][% ELSE %][% change %][% END %];
GRANT USAGE ON SCHEMA [% IF name %][% name %][% ELSE %][% change %][% END %] TO viewer;

COMMIT;

pg_revert_create_schema.tmpl

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

BEGIN;

DROP SCHEMA [% IF name %][% name %][% ELSE %][% change %][% END %];

COMMIT;

pg_verify_create_schema.tmpl

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

BEGIN;

SELECT pg_catalog.has_schema_privilege('[% IF name %][% name %][% ELSE %][% change %][% END %]', 'usage');

ROLLBACK;