Home > mailing lists

Re: [GENERAL] COPY ... FROM stdin WITH FORMAT csv - Mailing list pgsql-general

From	Alexander Farber
Subject	Re: [GENERAL] COPY ... FROM stdin WITH FORMAT csv
Date	March 21, 2017 22:11:53
Msg-id	CAADeyWhMCPmowH4ApT=Jn_MKn2gH=3_Zot=our0b50oHsxKcVQ@mail.gmail.com Whole thread Raw
In response to	Re: [GENERAL] COPY ... FROM stdin WITH FORMAT csv (Francisco Olarte <folarte@peoplecall.com>)
Responses	Re: [GENERAL] COPY ... FROM stdin WITH FORMAT csv Re: [GENERAL] COPY ... FROM stdin WITH FORMAT csv
List	pgsql-general

Thank you - this has worked:

COPY words_reviews (uid, author, nice, review, updated) FROM stdin WITH (FORMAT csv);

1,2,1,'1 is nice by 2','2017-03-01'

1,3,1,'1 is nice by 3','2017-03-02'

1,4,1,'1 is nice by 4','2017-03-03'

2,1,1,'2 is nice by 1','2017-03-01'

2,3,1,'2 is nice by 3','2017-03-02'

2,4,0,'2 is not nice by 4','2017-03-03'

but I am confused about the comments that I should use \copy and not just COPY and also that I could leave out WITH and brackets.

Because please take a look at the 9.6.2 psql output (COPY works, and leaving out WITH brackets - not):

words=> COPY words_reviews (uid, author, nice, review, updated) FROM stdin WITH (FORMAT csv);

Enter data to be copied followed by a newline.

End with a backslash and a period on a line by itself.

>> 1,2,1,'1 is nice by 2','2017-03-01'

1,3,1,'1 is nice by 3','2017-03-02'

1,4,1,'1 is nice by 4','2017-03-03'

2,1,1,'2 is nice by 1','2017-03-01'

2,3,1,'2 is nice by 3','2017-03-02'

2,4,0,'2 is not nice by 4','2017-03-03'

>> >> >> >> >> >> COPY 6

words=> COPY words_reviews (uid, author, nice, review, updated) FROM stdin FORMAT csv;

ERROR: syntax error at or near "FORMAT"

LINE 1: ...s (uid, author, nice, review, updated) FROM stdin FORMAT csv...

From: Francisco Olarte
Date: 21 March 2017, 21:11:48
Subject: Re: [GENERAL] COPY ... FROM stdin WITH FORMAT csv

From: "David G. Johnston"
Date: 21 March 2017, 22:21:13
Subject: Re: [GENERAL] COPY ... FROM stdin WITH FORMAT csv