Home > mailing lists

Re: Sequence reset - Mailing list pgsql-general

From	Rikard Bosnjakovic
Subject	Re: Sequence reset
Date	August 23, 2010 14:46:48
Msg-id	AANLkTimLrejCJs89VQHcq5_6LrEEPVj_qxhryUWyMhQ5@mail.gmail.com Whole thread Raw
In response to	Sequence reset ("SUNDAY A. OLUTAYO" <olutayo@sadeeb.com>)
List	pgsql-general

Tree view

On Mon, Aug 23, 2010 at 12:04, SUNDAY A. OLUTAYO <olutayo@sadeeb.com> wrote:

> How can I reset a sequence column due to deletion of some rolls?

ALTER SEQUENCE sequence_name RESTART 1;


--
- Rikard

pgsql-general by date:

From: akp geek
Date: 23 August 2010, 14:33:05
Subject: Tool to compare data between tables

From: Leif Jensen
Date: 23 August 2010, 15:40:32
Subject: ECPG & threads

Re: Sequence reset - Mailing list pgsql-general

Previous

Next