bulk imports with sequence - Mailing list pgsql-sql

From Aaron Held
Subject bulk imports with sequence
Date
Msg-id 000b01c24840$7b5a0880$4b00a8c0@metrony.com
Whole thread Raw
In response to Re: sql subqueries problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: bulk imports with sequence  ("Dan Langille" <dan@langille.org>)
Re: bulk imports with sequence  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I am importing a large number of records monthly using the \copy (from text file)command.

I would like to use a sequence as a unique row ID for display in my app.

Is there any way to let postgresql generate the sequence itself.  Currently the only way I
can make it work is to grab the next seq value and insert my own numbers into the file

Thank You,
-Aaron Held



pgsql-sql by date:

Previous
From: "Falk Nisius"
Date:
Subject: How to prevent recursion
Next
From: "Dan Langille"
Date:
Subject: Re: bulk imports with sequence