"karsten vennemann" <karsten@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general