Re: Sequence reset - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Sequence reset
Date
Msg-id 4C7249FC.2030001@iol.ie
Whole thread Raw
In response to Sequence reset  ("SUNDAY A. OLUTAYO" <olutayo@sadeeb.com>)
List pgsql-general
On 23/08/2010 11:04, SUNDAY A. OLUTAYO wrote:
> How can I reset a sequence column due to deletion of some rolls?

You can use the setval() function to set its value to whatever you like:

http://www.postgresql.org/docs/8.4/static/functions-sequence.html

HTH

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Garry Saddington
Date:
Subject: disappearing data
Next
From: Magnus Hagander
Date:
Subject: Re: disappearing data