PostgreSQLでシーケンスを今の最大値にリセットする ref: http://qiita.com/unarist@github/items/1ef370933d5745d9c336

file0.sql

select
      'select setval(''' || sequence || ''', (select max(' || column_name || ') from ' || table_name || '));' as setval
from
    ( 
        select
              table_name
            , column_name
            , substr(column_default, 10, length(column_default) - 21) as sequence 
        from
            information_schema.columns 
        where
            table_schema = 'public' 
            and column_default like 'nextval(%'
    ) a;