On Monday, January 16, 2017, Rich Shepard <
rshepard@appl-ecosys.com> 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@agsprayinc.com','','Chemicals','Opportunity',''),
Identifiers, if quoted at all, must quoted using double-quotes. "comp_id","comp_name"...
David J.