Re: CREATE TABLE initial value for PRIMARY KEY

Maurice Yarrow wrote:

> So it turned out to be possible to do it like this:
>
> CREATE SEQUENCE id_seq;
> SELECT setval('id_seq',100111);

FYI, you could have done this:

CREATE SEQUENCE id_seq START 100111;

- John D. Burger
MITRE