serial field starting at specific value

From: Robert Mosher <mosher(at)andrews(dot)edu>
To: Mailing List Postgresql <pgsql-novice(at)postgresql(dot)org>
Subject: serial field starting at specific value
Date: 2003-01-31 20:04:36
Message-ID: Pine.SOL.3.91.1030131145913.3432B-100000@edmund.cs.andrews.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is there a way I can specify which value a serial field starts at? I
would like to have it start at some arbitrary value, say 10, or 100, so
that no element in a table has a key lower than that.

Thanks,
Rob Mosher

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luis Magaña 2003-01-31 21:21:17 For each record in SELECT
Previous Message Reshat Sabiq 2003-01-31 19:18:54 Re: can only connect to localhost is postgresql