Re: [SQL] bulk imports with sequence

2002-08-20 Thread Tom Lane
"Aaron Held" <[EMAIL PROTECTED]> writes: > 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

Re: [SQL] bulk imports with sequence

2002-08-20 Thread Dan Langille
On 20 Aug 2002 at 7:55, Aaron Held wrote: > 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. > Currentl

[SQL] bulk imports with sequence

2002-08-20 Thread Aaron Held
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