Postgres Pro
Downloads
Home   >   mailing lists

setting serial start value - Mailing list pgsql-general

From Greg Philpott
Subject setting serial start value
Date
Msg-id B386F91C-3583-4767-9FA0-673C95CB79FD@mdialogue.com
Whole thread Raw
Responses Re: setting serial start value  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: Column info without executing query
Next
From: Michael Fuhr
Date:
Subject: Re: setting serial start value