public inbox for [email protected]  

help / color / mirror / Atom feed

From: Fujii Masao <[email protected]>
To: Daniel Gustafsson <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: Missing File weather.txt
Date: Sun, 6 Jul 2025 02:17:50 +0900
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>



On 2020/01/28 19:18, Daniel Gustafsson wrote:
>> On 28 Jan 2020, at 03:22, PG Doc comments form <[email protected]> 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/[email protected]

-- 
Fujii Masao
NTT DATA Japan Corporation

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Missing File weather.txt
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox