Re: copy from - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: copy from
Date
Msg-id Pine.BSF.4.10.10008150933170.86366-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: copy from  ("Adam Lang" <aalang@rutgersinsurance.com>)
List pgsql-sql
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?



pgsql-sql by date:

Previous
From: Thomas Swan
Date:
Subject: Re: Functions with Null Arguments?
Next
From: Stephan Szabo
Date:
Subject: Re: My Indices doesn't work