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