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

Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.

From: Jure Kobal <jure(dot)kobal(at)gmx(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.
Date: 2009-07-20 19:09:56
Message-ID: 200907202110.00779.jure.kobal@gmx.com (view raw or flat)
Thread:
Lists: pgsql-novice
The info for the serial is stored in a seperate table which name should be 
something like <table_name>_<column_name>_seq where table_name is the name of 
the table and column_name the name of the serial you're using.
It should look something like

 sequence_name | last_value | increment_by | ...
-------------------+------------+---------------+ ...
    album_seq     |        461   |            1      | ...

you would need to change the last_value column.

Regards
Jure


On Monday 20 of July 2009 20:54:33 JORGE MALDONADO wrote:
> How can a serial or bigserial field start from 1 again?
> I need to manually remove all the records from a table and I need these
> kind of fields to start from 1 once again.
>
> With respect,
> Jorge Maldonado

In response to

pgsql-novice by date

Next:From: Michael WoodDate: 2009-07-20 19:27:41
Subject: Re: How to insert data from a text file
Previous:From: JORGE MALDONADODate: 2009-07-20 18:54:33
Subject: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.

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