Re: Reset sequence number

From: missive(at)frontiernet(dot)net (Lee Harr)
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Reset sequence number
Date: 2002-02-23 17:07:34
Message-ID: slrna7fiul.5v.missive@whave.frontiernet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> How can I reset a sequence number back to 0 ?
>

SELECT setval('sequence_name', 0);

In order for this to work, the sequence must have been created with
a MINVALUE of 0 (the default MINVALUE is 1)

CREATE SEQUENCE sequence_name MINVALUE 0;

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2002-02-23 17:18:14 Re: psql --single-step mode doesn't like empty sets
Previous Message Ivan il Terribile 2002-02-23 12:51:10 Re: passing argument ro a trigger