| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 9.6.1: INSERT with PK as serial |
| Date: | 2017-01-17 00:37:29 |
| Message-ID: | CAKJS1f8o7_ExaHJYx_UZq=t4wRd_XZ0SUzLbWEjGMLD1ZYLtkA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 17 January 2017 at 13:30, Rich Shepard <rshepard(at)appl-ecosys(dot)com> 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(at)agsprayinc(dot)com','','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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-01-17 00:39:20 | Re: 9.6.1: INSERT with PK as serial |
| Previous Message | John R Pierce | 2017-01-17 00:35:45 | Re: 9.6.1: INSERT with PK as serial |