Sqitch create type templates for pg engine

pg_deploy_create_type.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 TYPE [% IF name %][% name %][% ELSE %][% change %][% END %] AS (
  [%- FOREACH attr IN attribute -%]
    [% attr %] [% type.item( loop.index ) or 'TEXT' %] NOT NULL[% loop.last ? '' : ', ' %]
  [%- END -%]
);

COMMIT;

pg_revert_create_type.tmpl

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

BEGIN;

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

COMMIT;

pg_verify_create_type.tmpl

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

BEGIN;

SELECT true
FROM pg_type t
JOIN pg_namespace n ON t.typnamespace = n.oid
WHERE typname = '[% IF name %][% name %][% ELSE %][% change %][% END %]'
[% IF schema %]AND n.nspname = '[% schema %]'[% END %];

ROLLBACK;