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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
