Re: Sequence reset

From: Rikard Bosnjakovic <rikard(dot)bosnjakovic(at)gmail(dot)com>
To: "SUNDAY A(dot) OLUTAYO" <olutayo(at)sadeeb(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sequence reset
Date: 2010-08-23 14:46:34
Message-ID: AANLkTimLrejCJs89VQHcq5_6LrEEPVj_qxhryUWyMhQ5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

ALTER SEQUENCE sequence_name RESTART 1;

--
- Rikard

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leif Jensen 2010-08-23 15:19:35 ECPG & threads
Previous Message akp geek 2010-08-23 14:32:49 Tool to compare data between tables