Re: resetting sequence

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
>