Re: Resetting sequence - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Resetting sequence
Date
Msg-id 20050125230442.GA96518@winnie.fuhr.org
Whole thread Raw
In response to Resetting sequence  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
On Tue, Jan 25, 2005 at 05:19:41PM -0500, Keith Worthington wrote:

> I would like to know if the sequence can be reset such that the next
> time a record is written into the table it will have a value of 1.

See ALTER SEQUENCE and the "Sequence Manipulation Functions" section
in the "Functions and Operators" chapter in the documentation.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: Resetting sequence
Next
From: Ramon Orticio
Date:
Subject: printing reports for posgresql