Re: 9.6.1: INSERT with PK as serial

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 1/16/2017 4:30 PM, Rich Shepard wrote:

  I noticed that, too. Here's the first line:

INSERT INTO companies
('comp_id','comp_name','addr1','addr2','city','comp_state','postcode','country','phone','fax','e_mail','url','industry','status','comment')
VALUES
(1,'AG Spray Inc.',' ','PO Box
12129','Salem','OR','97309-0129','USA','503-371-7907','888-273-0937','info@xxxxxxxxxxxxxx','','Chemicals','Opportunity',''),

the above isn't valid postgresql, as field names need to be in "doublequotes" not 'singlequotes'.

but thats not the INSERT statement your error logged...

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

note no list of fields.    note no PK value.   AND no quotes around the values.

-- 
john r pierce, recycling bits in santa cruz