Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id CC67B475AF9
	for <pgsql-sql@postgresql.org>; Tue, 20 Aug 2002 07:55:08 -0400 (EDT)
Received: from metrony.com (webware.metrony.com [207.159.131.106])
	by postgresql.org (Postfix) with ESMTP id 007314759F5
	for <pgsql-sql@postgresql.org>; Tue, 20 Aug 2002 07:55:08 -0400 (EDT)
Received: from aaronlaptop (ool-4350168d.dyn.optonline.net [67.80.22.141])
	by metrony.com (8.11.0/8.11.0) with SMTP id g7KBtAT57675
	for <pgsql-sql@postgresql.org>; Tue, 20 Aug 2002 11:55:10 GMT
	(envelope-from aaron@metrony.com)
Message-ID: <000b01c24840$7b5a0880$4b00a8c0@metrony.com>
From: "Aaron Held" <aaron@metrony.com>
To: <pgsql-sql@postgresql.org>
References: <20020819094344.C31592-100000@megazone23.bigpanda.com>
	<761958859.1029831297@sauron>
Subject: bulk imports with sequence
Date: Tue, 20 Aug 2002 07:55:24 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/289
X-Sequence-Number: 9135

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 value and insert my own numbers into the file

Thank You,
-Aaron Held