Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: Lacey Powers <lacey(dot)powers(at)commandprompt(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.
Date: 2009-07-22 07:17:17
Message-ID: 5a8aa6680907220017q2cfe201bq49a62af1483ea1d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

2009/7/21 Lacey Powers <lacey(dot)powers(at)commandprompt(dot)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(at)gmail(dot)com>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Net Tree Inc. 2009-07-23 06:36:13 Question on Load balancing
Previous Message Lacey Powers 2009-07-22 00:41:17 Re: trouble connecting to DB