Re: 9.6.1: INSERT with PK as serial

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(at)agsprayinc(dot)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