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