Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1. - Mailing list pgsql-novice

From Michael Wood
Subject Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.
Date
Msg-id 5a8aa6680907220017q2cfe201bq49a62af1483ea1d4@mail.gmail.com
Whole thread Raw
In response to Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.  (Lacey Powers <lacey.powers@commandprompt.com>)
List pgsql-novice
2009/7/21 Lacey Powers <lacey.powers@commandprompt.com>:
> Hello Jorge,
>
> An even easier way to accomplish this would be to use the following:
>
> ALTER SEQUENCE <sequence_name> RESTART WITH 1;
>
> As shown in the documentation, here:
>
> http://www.postgresql.org/docs/8.3/interactive/sql-altersequence.html

Ah, good point :)

--
Michael Wood <esiotrot@gmail.com>

pgsql-novice by date:

Previous
From: Lacey Powers
Date:
Subject: Re: trouble connecting to DB
Next
From: "Net Tree Inc."
Date:
Subject: Load Balance