take a look at the SETVAL function... it's something close to:
SELECT SETVAL('sequence_name', 1);
something like that. check the manual.
On Tue, 26 Mar 2002, Kancha . wrote:
> My sequence starts from 1 and after few months it
> should be reset to 1 again. Can this be automated ??
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy Awards�
> http://movies.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>