Re: 9.6.1: INSERT with PK as serial

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Monday, January 16, 2017, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
> On Mon, 16 Jan 2017, Tom Lane wrote:
>
> > It looks like something deleted the quote marks.  How are you entering
> > this SQL command, exactly?
>
> Tom,
>
>   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',''),

Identifiers, if quoted at all, must quoted using double-quotes.  "comp_id","comp_name"...

David J.