en
> -Original Message-
> From: Tom Lane [mailto:t...@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" 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 C