Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1uY6WZ-0018Z5-Cp
	for pgsql-docs@arkaria.postgresql.org; Sat, 05 Jul 2025 17:18:03 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1uY6WW-008FeK-SH
	for pgsql-docs@arkaria.postgresql.org; Sat, 05 Jul 2025 17:18:01 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <masao.fujii@oss.nttdata.com>)
	id 1uY6WW-008Fdy-KV
	for pgsql-docs@lists.postgresql.org; Sat, 05 Jul 2025 17:18:01 +0000
Received: from oss.nttdata.com ([49.212.34.109])
	by magus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <masao.fujii@oss.nttdata.com>)
	id 1uY6WT-005vOr-0h
	for pgsql-docs@lists.postgresql.org;
	Sat, 05 Jul 2025 17:17:59 +0000
Received: from [192.168.11.9] (p1696134-ipoe.ipoe.ocn.ne.jp [118.0.93.133])
	by oss.nttdata.com (Postfix) with ESMTPSA id 5831361C08;
	Sun,  6 Jul 2025 02:17:51 +0900 (JST)
X-Virus-Status: Clean
X-Virus-Scanned: clamav-milter 0.103.11 at oss.nttdata.com
Message-ID: <89bd784e-c3ab-4d9e-9be1-0846bd8c260c@oss.nttdata.com>
Date: Sun, 6 Jul 2025 02:17:50 +0900
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Missing File weather.txt
Content-Language: en-US
To: Daniel Gustafsson <daniel@yesql.se>, davidhowes@gmail.com,
 pgsql-docs@lists.postgresql.org
References: <158017814191.19852.15019251381150731439@wrigleys.postgresql.org>
 <68FE7D96-3F05-40E3-B3A2-04CE267CF28A@yesql.se>
From: Fujii Masao <masao.fujii@oss.nttdata.com>
In-Reply-To: <68FE7D96-3F05-40E3-B3A2-04CE267CF28A@yesql.se>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/89bd784e-c3ab-4d9e-9be1-0846bd8c260c%40oss.nttdata.com>
Precedence: bulk



On 2020/01/28 19:18, Daniel Gustafsson wrote:
>> On 28 Jan 2020, at 03:22, PG Doc comments form <noreply@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.1136715805440673517@wrigleys.postgresql.org

-- 
Fujii Masao
NTT DATA Japan Corporation