Re: COPY ... FROM stdin WITH FORMAT csv

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY ... FROM stdin WITH FORMAT csv
Date: 2017-03-22 15:15:23
Message-ID: CAADeyWhaDn4X0JwNMhuEkKseBvLXE-xyk6j=vYXhHNDXZbANew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi David,

On Tue, Mar 21, 2017 at 8:21 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Tuesday, March 21, 2017, Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
wrote:
>>
>> words=> COPY words_reviews (uid, author, nice, review, updated) FROM
stdin FORMAT csv;
>
>
> What did you read that lead you to think the above shoud work?
>

ok thanks, I had misunderstood your text -

"The above means the entire "WITH" section is optional, as is the word
WITH. However, if you want to add "with" options they must appear within
parentheses, those are not optional. Multiple options can appear within
the single set of parentheses."

I think the root cause is that it is difficult to understand an english
sentence trying to describe a keyword "with" :-)

Regards
Alex

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Glen Huang 2017-03-22 16:54:34 How to create unique index on multiple columns where the combination doesn't matter?
Previous Message Moreno Andreo 2017-03-22 14:40:39 Re: Google Cloud Platform, snapshots and WAL