Re: Resetting sequence

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Keith Worthington <keithw(at)narrowpathinc(dot)com>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Resetting sequence
Date: 2005-01-25 23:04:42
Message-ID: 20050125230442.GA96518@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ramon Orticio 2005-01-26 09:23:23 printing reports for posgresql
Previous Message Keith Worthington 2005-01-25 22:19:41 Resetting sequence