Re: 9.6.1: INSERT with PK as serial

On Tue, 17 Jan 2017, David Rowley wrote:

> You may have more luck getting an answer if you include the statement
> causing the problem.

David,

Here's an example:

INSERT INTO companies VALUES
(1,'AG Spray Inc.',,'PO Box 12129','Salem','OR','97309-0129','USA','503-371-7907','888-273-0937','info(at)agsprayinc(dot)com',,'Chemicals','Opportunity'),

and the associated error message:

psql:companies.sql:1: ERROR: syntax error at or near "Spray"
LINE 1: INSERT INTO companies VALUES (AG Spray Inc.,,PO Box 12129,Sa...

> If you're not specifying the column names, then the VALUES list must
> have the same number of values, in the same order as the columns
> defined on the table.

As I wrote in the original message, I did this.

Rich