DECLARE @id_name VARCHAR(50);
DECLARE @table_name VARCHAR(50);

SET @id_name='ACTION_ID';
SET @table_name='ACTIONS_LOG'

EXEC ('SELECT MAX('+@id_name+') FROM '+@table_name+'');

CREATE OR REPLACE FUNCTION "METR"."restart_table"(table_name varchar(50), id_name varchar(50))
RETURNS VOID AS $$
DECLARE DSQL varchar(2000);
DECLARE Num int;
BEGIN
	 create table Temp(ID_Value int);
	 set DSQL = 'insert into Temp(ID_Value) select max('||id_name||')+1 from '||table_name;
	 --EXECUTE DSQL;<---Тут выполнение
	 set Num = (select ID_Value from Temp);
	 if (NUM is not null )
	 then
	 	 set DSQL = 'alter table '||table_name||' alter column '||id_name||' restart with '||cast(Num as char(10));
		 --EXECUTE DSQL;<---Тут выполнение
	 end if;
	 drop table Temp;
END;
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION "METR"."restart_table"(table_name varchar(50), id_name varchar(50))
RETURNS VOID AS $$
DECLARE DSQL varchar(2000);
DECLARE Num int;
BEGIN
	 create table Temp(ID_Value int);
	 DSQL = 'insert into Temp(ID_Value) select max('|| id_name ||')+1 from ' || table_name;
	 EXECUTE DSQL;
	 Num = (select ID_Value from Temp);
	 if (Num is not null )
	 then
	 	 DSQL = 'alter table '||table_name||' alter column '||id_name||' restart with '||cast(Num as char(10));
		 EXECUTE DSQL;
	 end if;
	 drop table Temp;
END;
$$ LANGUAGE plpgsql;