[GENERAL] 9.6.1: INSERT with PK as serial - Mailing list pgsql-general

   I have a table with the primary key type of serial. The initial data load
has 40 lines, and each has a value for every column including sequential
integers from 1 through 40 for the data. When I try to read it in using
'psql -d <database_name> -f <filename.sql>' I get a syntax error at the
second word in the string that is column 2. The error message does not print
the integer PK. If it matters, I have all 14 columns specified but not
explicitly named in the INSERT INTO command.

   I've looked in the manual without learning how to INSERT data in a table
with a serial PK and need to learn how to do this.

Rich