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
sszabo@bigpanda.com
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?