Re: Missing File weather.txt - Mailing list pgsql-docs

From Daniel Gustafsson
Subject Re: Missing File weather.txt
Date
Msg-id 4DF3BEAF-EAAA-4C91-92B3-2CA8F022B383@yesql.se
Whole thread Raw
In response to Re: Missing File weather.txt  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Missing File weather.txt
List pgsql-docs
> On 5 Jul 2025, at 19:29, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> 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 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.
>
> +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:".

The attached v2 adds the missing line, and tweaks the text added to document
the file.  Since there have been reports I propose backpatching this all the
way down to 13 while at it.

--
Daniel Gustafsson


Attachment

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Outdated typedefs in documentation
Next
From: Fujii Masao
Date:
Subject: Re: Missing File weather.txt