Thank you Poul and Justin, I'll give it a try!!!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
I believe you could also create the sequence, then update it with
setval('', );
Regards and best wishes,
Justin Clift
"Poul L. Christiansen" wrote:
>
> Yes, there is.
>
> When you create a serial column a sequence is created, which does the
> counting.
>
> You can create a serial column
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)-
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
cbel
