Well, if you define your main table to have a serial, or an explicit default nextval(seqid), you won't even need to do that. Just leave the column off the insert list and the default should fill it for you. Stephan Szabo [EMAIL PROTECTED] On Tue, 15 Aug 2000, Adam Lang wrote: > I get it. I upload to the temp table, then for the select/insert I just do > the nextval(seq_id) for the primary key field, correct?
- [SQL] copy from Adam Lang
- Re: [SQL] copy from Adam Lang
- Re: [SQL] copy from Stephan Szabo
- Re: [SQL] copy from Adam Lang
- Re: [SQL] copy from Stephan Szabo
- Re: [SQL] copy from Adam Lang
- Re: [SQL] copy from Stephan Szabo