Coming from another newbie, here's what I use to set the sequence
following an import of text data. I create seqence and table and import
one file at a time, for a one time conversion, so I don't need the table
of table names,etc., but that's a great idea, like a data dictionary
concept. Would this work, modified to fit your loop syntax?
select SETVAL('link_rep_link_rep_id_seq', (select max(link_rep_id) from
link_rep))
Jim