Re: Re: Simple search question - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Re: Simple search question
Date
Msg-id 00d801bfd6fd$41344dc0$0c64010a@kick.com
Whole thread Raw
In response to Simple search question  (Alex <gliathit@ihug.com.au>)
List pgsql-sql
> This brings me back to another unanswered question recently posted
up,maybe
> it is impossible...
> I declared a new table with one of the types as serial (which is really
just a
> sort of macro I believe, which automates the creation of a few things for
your
> convenience), which initialises the last_value of the relation (the
sequence
> itself), as 1. Therefore, upon INSERTing my first row, the serial number
began
> at 1, next was 2, then 3, and so forth.
>  My question is, is it possible to alter the sequence last_value column,
as
> I need the serial number to begin from 1000?

select setval(sequencename, value); should set the sequence as if value was
the last value given out in the sequence.




pgsql-sql by date:

Previous
From: Webb Sprague
Date:
Subject: Re: \copy...
Next
From: mikeo
Date:
Subject: Re: Re: Simple search question