How to reset sequence with postgresql?

Sometimes, you meet a problem with sequence with database. It means your sequence all reset to start with 1 again.

So this is solution that we take the maximum value from each table.

-----------------------Create Function ---------------------------------
CREATE OR REPLACE FUNCTION "reset_sequence" (tablename text, columnname text, sequence_name text) RETURNS "pg_catalog"."void" AS
    $body$
      DECLARE
      BEGIN
      EXECUTE 'SELECT setval( ''' || sequence_name  || ''', ' || '(SELECT MAX(' || columnname || ') FROM ' || tablename || ')' || '+1)';
      END;
    $body$  LANGUAGE 'plpgsql';


-----------------------Call Function ---------------------------------

  select table_name || '_' || column_name || '_seq',
    reset_sequence(table_name, column_name, table_name || '_' || column_name || '_seq')
    from information_schema.columns where column_default like 'nextval%';