Sqitch create table templates for pg engine

pg_deploy_create_table.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 TABLE [% IF name %][% name %][% ELSE %][% change %][% END %] (
[% FOREACH col IN column -%]
  [% col %] [% type.item( loop.index ) or 'TEXT' %] NOT NULL[% loop.last ? '' : ', ' %]
[% END -%]
);

COMMIT;

pg_revert_create_table.tmpl

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

BEGIN;

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

COMMIT;

pg_verify_create_table.tmpl

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

BEGIN;

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

ROLLBACK;