The docs have it.
select setval('foobar_seq',value)
On Sun, 17 Jun 2001 zilch(at)home(dot)se wrote:
>
> Forgott how to set the value of a sequence,
> please tell.
>
> Daniel Akerud
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>