Postgres Pro
Downloads
Home   >   mailing lists

Adding Records With SERIAL Primary Key - Mailing list pgsql-general

From Rich Shepard
Subject Adding Records With SERIAL Primary Key
Date
Msg-id Pine.LNX.4.61.0505030950170.9945@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Adding Records With SERIAL Primary Key
List pgsql-general
Tree view 
   I may have missed this in the docs; if so, please tell me where to find the
answer there. If not, I still need to learn how to resolve this situation.

   The database schema has been designed and the tables are ready to be
created. Once they exist, I want to load data into the tables in batch mode
(rather than one at a time, manually). The core table has a SERIAL data type
field as the primary key. How is this field assigned values? Then, how do I
load the related tables so they reference the proper records?

Thanks,

Rich

--
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
<http://www.appl-ecosys.com>   Voice: 503-667-4517   Fax: 503-667-8863

pgsql-general by date:

Previous
From: Alex Turner
Date:
Subject: Re: Deep integration of PostgreSQL with Apache
Next
From: Ricardo Vaz Mannrich
Date:
Subject: Re: Dynamically access to field on a RECORD variable