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