Re: auto fill serial id field with default value in copy operation

Yes it worked when I ommited the serial field in the copy command (and in
the import source file). As a reference for others:

COPY records (quad_id, species_id, observation_value) from
'/var/www/data/data_import2.csv' using delimiters ','  with null as '';

Karsten



> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Friday, October 22, 2010 14:31
> To: karsten vennemann
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] auto fill serial id field with default
> value in copy operation
>
> "karsten vennemann" <karsten@terragis.net> writes:
> > What is the best way to load my data via copy into the db
> and get the record_id field auto filled (with the next id
> value in squence) ?
>
> You have to omit the column from the copy data altogether,
> and then list just the columns that are supplied in the data
> in the COPY command's column list.
>
>             regards, tom lane