Use a sequence and set the initial value of the sequence.
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Maurice Yarrow
> Sent: Friday, October 27, 2006 11:51 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] CREATE TABLE initial value for PRIMARY KEY
>
> Hello Postgres community
>
> Is there a formal way to set an initial value for a PRIMARY KEY
> when CREATE TABLE ? (This would be some large number,
> typically.)
>
> Or is it only possible to do this by first creating the table, and
> then inserting a bogus record forcing the initial value by
> specification (and then, presumably, deleting this bogus
> record) ?
>
> Maurice Yarrow
>
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster