On Tue, 2006-09-12 at 13:48, Brandon Aiken wrote:
> Serial fields have a default value of nextval, so if you add an 18th
> field to your text file with DEFAULT in every record it should work as
> intended.
Or you can use the
copy table (field1,field2,field3,...field18) from stdin;
syntax, and leave out the serial field from the list of columns.