Postgres Pro
Downloads
Home   >   mailing lists

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

From Maurice Yarrow
Subject CREATE TABLE initial value for PRIMARY KEY
Date
Msg-id 45425502.9030200@best.com
Whole thread Raw
Responses Re: CREATE TABLE initial value for PRIMARY KEY  ("Dann Corbit" <DCorbit@connx.com>)
Re: CREATE TABLE initial value for PRIMARY KEY  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: CREATE TABLE initial value for PRIMARY KEY  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Mailing list problem?
Next
From: "Dann Corbit"
Date:
Subject: Re: CREATE TABLE initial value for PRIMARY KEY