Received: from teak.adhesivemedia.com (teak.adhesivemedia.com [207.202.159.79]) by postgresql.org (Postfix) with ESMTP id 62D48475A41; Wed, 27 Mar 2002 00:30:06 -0500 (EST) Received: from localhost (philip@localhost) by teak.adhesivemedia.com (8.11.6/8.11.6) with ESMTP id g2R5UA037264; Tue, 26 Mar 2002 21:30:10 -0800 (PST) (envelope-from philip@adhesivemedia.com) Date: Tue, 26 Mar 2002 21:30:10 -0800 (PST) From: Philip Hallstrom To: "Kancha ." Cc: pgsql-general@postgresql.org, Subject: Re: resetting sequence In-Reply-To: <20020327023039.13665.qmail@web14914.mail.yahoo.com> Message-ID: <20020326212937.K37166-100000@teak.adhesivemedia.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE X-Archive-Number: 200203/1263 X-Sequence-Number: 22621 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=AE > http://movies.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >