On 2020/01/28 19:18, Daniel Gustafsson wrote:
On 28 Jan 2020, at 03:22, PG Doc comments form <nore...@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-populate.html
Description:
On this page https://www.postgresql.org/docs/12/tutorial-populate.html you
have this command:
COPY weather FROM '/home/user/weather.txt';
I've searched all over for weather.txt and can't find it. Please could you
make this and any other files required for the tutorial available and
provide clear instructions for accessing them at the beginning of the
tutorial.
This is only mentioned as an example of another input method, with a link to
the COPY page for more information. That being said, it's a good thing for a
tutorial to be self-contained, and going from a basic tutorial to the COPY
reference page is a fairly large step. I propose that we add a small example
on what weather.txt could look like as per the attached diff.
Sorry for reviving this old thread, but I wanted to follow up since
the same issue was reported again in [1], and the proposed patch
basically looks good to me.
Regarding the patch:
+<programlisting>
+San Francisco 46 50 0.25 1994-11-27
+Hayward 37 54 0.0 1994-11-29
+</programlisting>
In the tutorial, three rows are inserted using INSERT, so shouldn't
the sample input for COPY include all three, like this?
San Francisco 46 50 0.25 1994-11-27
San Francisco 43 57 0 1994-11-29
Hayward 37 54 \N 1994-11-29
Regards,
[1]
https://postgr.es/m/175166227769.3157504.1136715805440673...@wrigleys.postgresql.org
--
Fujii Masao
NTT DATA Japan Corporation
