Re: How to perform an identical insert?

Hi Axel,

have a look at this:
http://www.ca.postgresql.org/docs/aw_pgsql_book/node75.html


The postgres serial type is nothing more than a primary key with a
default-value as nextval('..') from a sequence and a trigger.

If you make this setup manually, you can load the data before attaching
the trigger and it should work. (Though I haven't tried this.)

Heiko

Axel Selk writes:
 > 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