[quote автор]Имя таблицы передается а функцию как входной параметр.
 Как передать этот же параметр(имя таблицы) в insert ?

CREATE or REPLACE FUNCTION lookup_letter4(text) RETURNS SETOF text AS $$
declare v_pk TEXT;
BEGIN
v_pk :='SELECT a.attname::text FROM   pg_index i
 JOIN   pg_attribute a ON a.attrelid = i.indrelid
                     AND a.attnum = ANY(i.indkey)
  where i.indrelid ='''||$1||'''::regclass limit 1'; 

IF v_pk in ('code','name') then 
execute 'INSERT INTO' ||$1|| '(code, name)
  --  VALUES (''-1'',''не задано'');';
END IF;
END;
$$ LANGUAGE plpgsql;

SELECT lookup_letter4('unsi_addons.aspr_boundary_type');[/quote]

CREATE or REPLACE FUNCTION lookup_letter4(text) RETURNS SETOF text AS $$
declare v_pk TEXT;
BEGIN
v_pk :='SELECT a.attname::text FROM   pg_index i
 JOIN   pg_attribute a ON a.attrelid = i.indrelid
                     AND a.attnum = ANY(i.indkey)
  where i.indrelid ='''||$1||'''::regclass limit 1'; 

IF v_pk in ('code','name') then 
execute 'INSERT INTO' ||qoute_ident($1)|| '(code, name)
  VALUES (''-1'',''не задано'');';
END IF;
END;
$$ LANGUAGE plpgsql; 

CREATE or REPLACE FUNCTION lookup_letter4(text) RETURNS SETOF text AS $$
declare v_pk TEXT;
BEGIN
v_pk :='SELECT a.attname::text FROM   pg_index i
 JOIN   pg_attribute a ON a.attrelid = i.indrelid
                     AND a.attnum = ANY(i.indkey)
  where i.indrelid ='''||$1||'''::regclass limit 1'; 

IF v_pk in ('code','name') then 
execute 'INSERT INTO' ||quote_ident($1)|| '(code, name)
  VALUES (''-1'',''не задано'');';
END IF;
END;
$$ LANGUAGE plpgsql; 

CREATE or REPLACE FUNCTION lookup_letter4(text) RETURNS SETOF text AS $$
declare v_pk TEXT;
BEGIN
SELECT a.attname::text FROM   pg_index i
 JOIN   pg_attribute a ON a.attrelid = i.indrelid
                     AND a.attnum = ANY(i.indkey)
  where i.indrelid =$1::regclass limit 1 into v_pk ; 

IF v_pk in ('code','name') then 
execute 'INSERT INTO ' ||$1|| '( code, name )
  VALUES (-1,''не задано'');';
END IF;
END;
$$ LANGUAGE plpgsql;