Serial Column Tweaking

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
Thread:
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]

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-10-07 19:34:46 Re: Serial Column Tweaking
Previous Message Louise Cofield 2003-10-07 19:05:02 Re: Copy table structure