On 17 January 2017 at 13:30, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
> 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',''),
single quotes are strings. double quotes may be used for identifiers.
In the column names list here you've mixed up the two.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
