From: Tom Lane <tgl@sss.pgh.pa.us>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
cc: Daniel Gustafsson <daniel@yesql.se>, davidhowes@gmail.com,
        pgsql-docs@lists.postgresql.org
Subject: Re: Missing File weather.txt
In-reply-to: <89bd784e-c3ab-4d9e-9be1-0846bd8c260c@oss.nttdata.com>
References: <158017814191.19852.15019251381150731439@wrigleys.postgresql.org>
 <68FE7D96-3F05-40E3-B3A2-04CE267CF28A@yesql.se>
 <89bd784e-c3ab-4d9e-9be1-0846bd8c260c@oss.nttdata.com>
Comments: In-reply-to Fujii Masao <masao.fujii@oss.nttdata.com>
	message dated "Sun, 06 Jul 2025 02:17:50 +0900"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <10239.1751736559.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sat, 05 Jul 2025 13:29:19 -0400
Message-ID: <10240.1751736559@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/10240.1751736559%40sss.pgh.pa.us>
Precedence: bulk

Fujii Masao <masao.fujii@oss.nttdata.com> writes:
> On 2020/01/28 19:18, Daniel Gustafsson wrote:
>> This is only mentioned as an example of another input method, with a li=
nk 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 C=
OPY
>> reference page is a fairly large step.  I propose that we add a small e=
xample
>> 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.

+1

> In the tutorial, three rows are inserted using INSERT, so shouldn't
> the sample input for COPY include all three, like this?

Agreed, the example file should match what the tutorial expects to be
in the table.  I'd include text along the lines of "The data inserted
above could also be inserted from a file containing:".

			regards, tom lane