Re: CREATE TABLE initial value for PRIMARY KEY

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Maurice Yarrow <yarrow(at)best(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: CREATE TABLE initial value for PRIMARY KEY
Date: 2006-10-27 19:16:40
Message-ID: 883690.94434.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is there a formal way to set an initial value for a PRIMARY KEY
> when CREATE TABLE ? (This would be some large number,
> typically.)

I am not sure exact what you are looking for, but have you already looked at the default clause of
the create table statement?

http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html#AEN43517

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2006-10-27 19:37:18 Re: plpython.so
Previous Message Marc G. Fournier 2006-10-27 19:15:59 Re: Mailing list problem?