Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group