setting serial start value

From: Greg Philpott <gphilpott(at)mdialogue(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: setting serial start value
Date: 2006-07-21 01:32:56
Message-ID: B386F91C-3583-4767-9FA0-673C95CB79FD@mdialogue.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with a field called "id" that is a serial field and
pkey. I would like to set the the sequence to start at 10000 and
increase sequentially from there but I can't seem to get that to
work. any suggestions are greatly appreciated.

I am using version 7.4.7
Greg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-07-21 02:49:23 Re: setting serial start value
Previous Message Erik Jones 2006-07-21 00:13:08 Re: Column info without executing query