Re: Range of Serial values

Yes, there is.

When you create a serial column a sequence is created, which does the
counting.

You can create a serial column, drop the associated sequence and create
a new one with the command:
"CREATE SEQUENCE seqname START 1000".

See also "\h CREATE SEQUENCE".

HTH,
Poul L. Christansen

cbell wrote:
> 
> Hello everyone,
> 
> when creating a serial column, is there a way to specify which number it
> will start counting from?  For example, if you wanted all Serial ID's to
> start at 1000 and count up from there, with no numbers below that.
> 
> Thanks,
> Chris.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html