How to perform an identical insert?

From: "Axel Selk" <sel(at)biba(dot)uni-bremen(dot)de>
To: Postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: How to perform an identical insert?
Date: 2002-03-22 13:07:01
Message-ID: 3C9B2C75.74B3B5B@biba.uni-bremen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear list,
I have collected data in a Microsoft Access data base and I am trying
now to transfer this data to a postgres data base running on a Linux
computer. I generated SQL scripts for the structure as well as for the
data. I have trouble with the data inserts. I want to insert the MS
Access IDs into Postgres as all references are made to those IDs.
But I found only the ID serial format in Postgres, which does not accept
inserted IDs. Is there any way to insert the IDs from Access and then
using the serial ID for any further action in Postgres?

Please, advice.

With kind regards

Axel Selk
--

Dipl.-Ing. Axel Selk

Bremen Institute of Industrial Technology and
Applied Work Science (BIBA)
- Division BIBA PPC -
Hochschulring 20
28359 Bremen
Germany

phone: +49 (0)421-218-5637
fax: +49 (0)421-218-5551
www.biba.uni-bremen.de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Heiko Klein 2002-03-22 13:12:24 Re: ODBC problem
Previous Message mark 2002-03-22 12:19:45 Re: ODBC problem