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@agsprayinc.com','','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