| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(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:39:20 |
| Message-ID: | CAKFQuwYFrow4xaFO7bgCpOjFBM8COfiSFbfSdYosBKQq16bw4g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Monday, January 16, 2017, Rich Shepard <rshepard(at)appl-ecosys(dot)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(at)agsprayinc(dot)com','','Chemicals','Opportunity',''),
>
>
Identifiers, if quoted at all, must quoted using double-quotes.
"comp_id","comp_name"...
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2017-01-17 00:45:16 | Re: 9.6.1: INSERT with PK as serial [FIXED] |
| Previous Message | David Rowley | 2017-01-17 00:37:29 | Re: 9.6.1: INSERT with PK as serial |