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(at)bigpanda(dot)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?