On 20 Aug 2002 at 7:55, Aaron Held wrote:
> 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
> 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
create sequence mytable_id_seq;
alter table mytable alter column id set default
I'm looking for a computer job:
In response to
pgsql-sql by date
|Next:||From: Darrin Domoney||Date: 2002-08-20 13:15:48|
|Subject: Event recurrence - in database or in application code ????|
|Previous:||From: Aaron Held||Date: 2002-08-20 11:55:24|
|Subject: bulk imports with sequence|