Re: CREATE TABLE initial value for PRIMARY KEY - Mailing list pgsql-general

From John D. Burger
Subject Re: CREATE TABLE initial value for PRIMARY KEY
Date
Msg-id FEA2F973-B33B-4B62-A35A-F03B8A45BFB6@mitre.org
Whole thread Raw
In response to Re: CREATE TABLE initial value for PRIMARY KEY  (Maurice Yarrow <yarrow@best.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Taras Kopets"
Date:
Subject: Re: WAL Archiving under Windows
Next
From: Jamie Deppeler
Date:
Subject: Deleting Problem