Re: Learning Plpgsql ??

Jim Beckstrom <jrbeckstrom@sbcglobal.net> writes:

> 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

For really large tables

SELECT SETVAL('link_rep_link_rep_id_seq', (SELECT link_rep_id
FROM link_rep ORDER BY link_rep_id DESC LIMIT 1))

will be quite a bit faster (you'll save yourself a tablescan).