| Lists: | pgsql-novice |
|---|
| From: | David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | Judith Strawser <judiths(at)GTScompanies(dot)com> |
| Subject: | Serial Column Tweaking |
| Date: | 2003-10-07 19:25:23 |
| Message-ID: | 5.2.1.1.0.20031007121716.00ac00a0@mail.gtscompanies.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
We're converting a database from Oracle to PostGreSQL (7.3.4); many of our
tables have a sequential ID field as a prime key, populated in Oracle from
sequences; we would like to make these fields serial data types in
PostGreSQL (to simplify insert statements etc)--and we want to keep the ID
values from the existing tables; is there a way to set a minimum value for
the serial type? Or will we have to go to explicit sequences with defined
minimum values?
--
David Rickard
Software Engineer
The GTS Companies
A TechBooks Company
----------------------------------------------------------------------------------
The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA * York, PA * Boston MA * New Delhi, India
----------------------------------------------------------------------------------
David(dot)Rickard(at)GTSCompanies(dot)com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]
| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org, Judith Strawser <judiths(at)GTScompanies(dot)com> |
| Subject: | Re: Serial Column Tweaking |
| Date: | 2003-10-07 19:34:46 |
| Message-ID: | 20031007193446.GA14933@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
On Tue, Oct 07, 2003 at 12:25:23 -0700,
David Rickard <David(dot)Rickard(at)GTScompanies(dot)com> wrote:
> We're converting a database from Oracle to PostGreSQL (7.3.4); many of our
> tables have a sequential ID field as a prime key, populated in Oracle from
> sequences; we would like to make these fields serial data types in
> PostGreSQL (to simplify insert statements etc)--and we want to keep the ID
> values from the existing tables; is there a way to set a minimum value for
> the serial type? Or will we have to go to explicit sequences with defined
> minimum values?
When you use type serial a sequence is created. You can use setval to
set what value the sequence will give out next. Normally the associated
sequence name is tablename_columnname_seq .