Skip site navigation (1) Skip section navigation (2)

CREATE TABLE initial value for PRIMARY KEY

From: Maurice Yarrow <yarrow(at)best(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: CREATE TABLE initial value for PRIMARY KEY
Date: 2006-10-27 18:50:42
Message-ID: 45425502.9030200@best.com (view raw or flat)
Thread:
Lists: pgsql-general
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



Responses

pgsql-general by date

Next:From: Alvaro HerreraDate: 2006-10-27 18:54:41
Subject: Re: Mailing list problem?
Previous:From: Sandro DentellaDate: 2006-10-27 18:48:30
Subject: Simple OUTER JOIN doubt

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group